$$Excel-Macros$$ Macro to print outlook attachment and email body

2015-10-01 Thread B.N.Chethan Kumar
Dear Friends, I am using outlook 2010. Does anyone know how to print outlook attachment and body of email. As a request from new client, we print close to 1000 email per day. Please share if you any code which can either run in outlook or in excel sheet. Thanks -- Chethan -- Are you =EXP(E:

$$Excel-Macros$$ PDF file name with Subject line

2015-05-08 Thread B.N.Chethan Kumar
I am trying to download PDF attachment.. It is working, But need to add Subject along with file name when file is saved in the folder. Kindly advise. -- Chethan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of

$$Excel-Macros$$ PDF file name with Subject line

2015-05-08 Thread B.N.Chethan Kumar
-- Chethan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

$$Excel-Macros$$ how to download PDF to specific folder

2015-05-08 Thread B.N.Chethan Kumar
Respected sir, I am using the following code to download "PDF" from Outlook. But it is giving error message. Kindly let me know how to fix it. Sub Test()'Arg 1 = Folder name of folder inside your Inbox 'Arg 2 = File extension, "" is every file 'Arg 3 = Save folder, "C:\Users\Ron\test" or "" '

Re: $$Excel-Macros$$ Re: Move coloum

2015-05-07 Thread B.N.Chethan Kumar
xlPasteAll > Else > Selection.Offset(0, 1).PasteSpecial Paste:=xlPasteAll > End If > > Next > End Sub > > > On Thu, May 7, 2015 at 6:33 PM, B.N.Chethan Kumar < > chetankumar1...@gmail.com> wrote: > >> Yes. it is single column "A:A

Re: $$Excel-Macros$$ Re: Move coloum

2015-05-07 Thread B.N.Chethan Kumar
Yes. it is single column "A:A" On Thu, May 7, 2015 at 12:20 PM, Mandeep Baluja wrote: > how is your sheet data.??? it contain a single column or multiple columns > ?? > > > > > On Wednesday, May 6, 2015 at 11:11:10 PM UTC+5:30, Chethan wrote: >> >> Hi, >> >> I need some help in modify the Macro.

$$Excel-Macros$$ Move coloum

2015-05-06 Thread B.N.Chethan Kumar
Hi, I need some help in modify the Macro. Current it combine multiple sheet in one column. I need to copy each sheet to one column, Like Sheet 1 to A Sheet 2 to B Sheet 3 to C Sheet 4 to D Etc.. Sub Combine() Dim J As Integer Dim rey As Range On Error Resume Next Sheets(1).Select Worksheets.A

$$Excel-Macros$$ excel Macro

2015-04-18 Thread B.N.Chethan Kumar
Hi Please help me with macro code. I am trying to send file to each individual. I need to filter and send the file to each individual. Current i have macro it work on person. -- Chethan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join

$$Excel-Macros$$ Open office

2014-05-23 Thread B.N.Chethan Kumar
Hi, Can we create macro in open office calc. I need to send file every hour using outlook. Regards CK -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULE

RE: $$Excel-Macros$$ Ie

2013-12-22 Thread B.N.Chethan Kumar
Hi. Please let me how to use HTML code in excel macro. I am trying to login into a tool and pull a report in PDF format. Regards Ck On Dec 21, 2013 12:46 AM, "B.N.Chethan Kumar" wrote: > Thanks. It worked. > On Dec 19, 2013 11:44 AM, "Ravinder" wrote: > &g

RE: $$Excel-Macros$$ VBA to send excel file using outlook

2013-12-20 Thread B.N.Chethan Kumar
It worked. . thanks On Dec 10, 2013 11:29 AM, "Ravinder" wrote: > give some examples > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *B.N.Chethan Kumar > *Sent:* Monday, December 09, 2013 6:13 PM > *

RE: $$Excel-Macros$$ Ie

2013-12-20 Thread B.N.Chethan Kumar
Thanks. It worked. On Dec 19, 2013 11:44 AM, "Ravinder" wrote: > Try this if looking for this.. actually in this you can login in yahoo > and gmail through form… > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behal

RE: $$Excel-Macros$$ Ie

2013-12-18 Thread B.N.Chethan Kumar
I am trying to connect Google \ analytics and pull report. On Dec 19, 2013 10:35 AM, "Ravinder" wrote: > Provide website and data you want to extract… > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *B.N.Chet

$$Excel-Macros$$ Ie

2013-12-18 Thread B.N.Chethan Kumar
Hi I am trying to connect IE 9 using vba and create a loop download data. Any help. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

Re: $$Excel-Macros$$ Sharepoint

2013-12-16 Thread B.N.Chethan Kumar
arepointdevelopmentlegacy > > > On Sat, Dec 14, 2013 at 4:15 PM, B.N.Chethan Kumar < > chetankumar1...@gmail.com> wrote: > >> Please help. >> On Dec 14, 2013 1:58 AM, "bhupendra singh raghav" < >> raghav.bhupen...@gmail.com> wrote: >> >&

Re: $$Excel-Macros$$ Sharepoint

2013-12-14 Thread B.N.Chethan Kumar
Please help. On Dec 14, 2013 1:58 AM, "bhupendra singh raghav" < raghav.bhupen...@gmail.com> wrote: > Yes > On Dec 14, 2013 1:56 AM, "B.N.Chethan Kumar" > wrote: > >> Hi. >> I am upload excel file to a SharePoint portal. In a day close to 100

$$Excel-Macros$$ Sharepoint

2013-12-13 Thread B.N.Chethan Kumar
Hi. I am upload excel file to a SharePoint portal. In a day close to 100 file need to be upload at different folder. Any macro which can automated it. Regards Ck -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this

$$Excel-Macros$$ VBA to send excel file using outlook

2013-12-09 Thread B.N.Chethan Kumar
I have to send excel as attachment to end user. But using different account. Like using "from" as a "Common I'd" -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ is there option to run macro program to pull data from outlook mail

2013-04-09 Thread B.N.Chethan Kumar
You can use code2 outlook addins. It does the same work with ease. On Apr 9, 2013 12:01 PM, "Prabhu Pinky" wrote: > Hi, > > For testing purpose, i have attached three mail herewith. > > This is not (.pst), i have copied sent items in my local folder. > > > On 9 April 2013 11:56, Abhishek Jain wr

Re: $$Excel-Macros$$ Power pivot

2013-03-26 Thread B.N.Chethan Kumar
aspx > > http://blogs.office.com/b/microsoft-excel/archive/2009/10/23/using-powerpivot-with-excel-2010.aspx > > http://blogs.office.com/b/microsoft-excel/archive/2011/05/24/getting-started-with-powerpivot-for-excel.aspx > > Regards > Ashish > > > > On Wed, Mar 27, 2013

$$Excel-Macros$$ Power pivot

2013-03-26 Thread B.N.Chethan Kumar
Hi, please help me some material on useage of power pivot in ms office 2010. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurat

Re: $$Excel-Macros$$ Need help with Macro

2012-10-16 Thread B.N.Chethan Kumar
Please help. On Oct 15, 2012 8:08 AM, "B.N.Chethan Kumar" wrote: > Dear Experts, > > Please help me with Macro. I need to assign a auditor for each Policy and > create worksheet for each auditor in same workbook by copy the policy to it. > > Kindly refer the attac

Re: $$Excel-Macros$$ All time high Price *

2012-09-21 Thread B.N.Chethan Kumar
Apology for delay response. Please find the example of how to use max function with conditonal. note: these is an array formuale. Regards CK On Fri, Sep 21, 2012 at 3:31 AM, dguillett1 wrote: > And just HOW is it MORE dynamic?? > > Don Guillett > Microsoft Excel Developer > SalesAid Softwa

Re: $$Excel-Macros$$ All time high Price

2012-09-20 Thread B.N.Chethan Kumar
Use max function On Sep 21, 2012 12:43 AM, "dguillett1" wrote: > Put this in the SHEET module > > Private Sub Worksheet_Change(ByVal Target As Range) > If Intersect(Target, Range("b1")) Is Nothing Then Exit Sub > Dim ss As Worksheet > Dim mf As Range > Set ss = Sheets("Monthly End Prices") > Se

Re: $$Excel-Macros$$ Re: Calculated Field not Working

2012-09-19 Thread B.N.Chethan Kumar
check..if these help. check and let me know Regards CK On Wed, Sep 19, 2012 at 2:45 PM, SG wrote: > Experts, > > plz help mei need solution.plz look in to this > > On Monday, September 17, 2012 8:20:53 PM UTC+5:30, SG wrote: > >> Hi Experts, >> >> I'm again in to a problem whic is silly but

Re: $$Excel-Macros$$ Fwd: PDF to excel table

2012-09-11 Thread B.N.Chethan Kumar
gt; > Sagar > On Tue, Sep 11, 2012 at 10:22 AM, B.N.Chethan Kumar < > chetankumar1...@gmail.com> wrote: > >> Apology friends, >> >> Please ignore my previous email. >> >> I need to convert attached PDF to Excel and we have close to 500 >> docum

Re: $$Excel-Macros$$ need to consolidate data in one sheet

2012-07-23 Thread B.N.Chethan Kumar
Hi Don, kindly explain how did you do that. Regards CK On Fri, Jul 20, 2012 at 8:56 AM, dguillett1 wrote: > See attached file that automatically makes a drop down in range d9 when > you activate the sheet and when you select the date from the drop down will > populate the cells. > > > Don Gu

Re: $$Excel-Macros$$ Re: Macro on daily task

2012-05-27 Thread B.N.Chethan Kumar
Hi, any update on my request On Fri, May 25, 2012 at 12:03 PM, B.N.Chethan Kumar < chetankumar1...@gmail.com> wrote: > Thanks Pascaal, > > Apology for delay response and thanks for working on the macro. > > As i was busy with kids first birthday, i did not reply to ur em

Re: $$Excel-Macros$$ Re: Macro on daily task

2012-05-24 Thread B.N.Chethan Kumar
Thanks Pascaal, Apology for delay response and thanks for working on the macro. As i was busy with kids first birthday, i did not reply to ur email. on the query raised. Current, i apply filter and search anything which start as "Win" & group them under "Brokerage win". Like wise "TCAP" under "

$$Excel-Macros$$ Help with PPT

2012-05-19 Thread B.N.Chethan Kumar
Dear friends, Do we have any macro which will automatic will update slide in PPT with same size and shape. If it is possible, please help with it. -- B.N Chetan kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Pl

Re: $$Excel-Macros$$ Insert rows in tables for comparison

2011-12-13 Thread B.N.Chethan Kumar
Please find the table in comparsion model. I have used pivot table option. Regards Chethan kumar BN On Wed, Dec 14, 2011 at 11:07 AM, Darwin Chan wrote: > Dear all, > > I have 2 tables concerning sales volume of several customers across 2 > months. I want to make a comparison on the sales volume

Re: $$Excel-Macros$$ Plz help urgent

2011-12-13 Thread B.N.Chethan Kumar
Please find the data in required format. Regards Chethan Kumar BN On Wed, Dec 14, 2011 at 12:46 PM, Anil Saxena wrote: > Plz let me know that how can possible to % in pivot table. base of Caller. > > Plz show the snap short also. > > -- > FORUM RULES (934+ members already BANNED for violation) >

Re: $$Excel-Macros$$ Correction in Formula

2011-12-02 Thread B.N.Chethan Kumar
Please find the information as requested On Sat, Dec 3, 2011 at 1:25 AM, Aamir Shahzad wrote: > Dear Group, > > I am using "Countifs" function how I give the second criteria e.g. I want > >9 it's mean only pick the buckets of 10,11 & 12. See the attached file > plz. > > Regards, > > Aamir Shahzad

Re: $$Excel-Macros$$ Need Help

2011-11-30 Thread B.N.Chethan Kumar
oftware > dguille...@gmail.com > > *From:* B.N.Chethan Kumar > *Sent:* Tuesday, November 29, 2011 5:03 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Need Help > > Hi, > > Thanks these help. > > But need some additional input. these work on

Re: $$Excel-Macros$$ Need Help

2011-11-29 Thread B.N.Chethan Kumar
Guillett > SalesAid Software > dguille...@gmail.com > > *From:* B.N.Chethan Kumar > *Sent:* Tuesday, November 29, 2011 4:04 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Need Help > > Hi All, > > I got these Macro template from one guys of

Re: $$Excel-Macros$$ Adding Conditional Formatting to an existing formula

2011-11-23 Thread B.N.Chethan Kumar
Hi Sunnie, The attached file with the condition format. Hope these is what your requirment was. Regards Chethan Kumar BN On Thu, Nov 24, 2011 at 5:18 AM, Susan 1 wrote: > I’m having trouble using the conditional formatting. > I’m trying to get a calculated value (would like to use the IF functi

Re: $$Excel-Macros$$ Number Formats in French

2011-10-28 Thread B.N.Chethan Kumar
Thanks SAM, I missed that part. please find the updated format. Regards Chethan Kumar BN On Sat, Oct 29, 2011 at 3:15 AM, Sam Mathai Chacko wrote: > The OP had requested for the decimal separator to be a comma (,) > > Sam > > > On Sat, Oct 29, 2011 at 3:07 AM, B.N.Chethan Kuma

Re: $$Excel-Macros$$ Number Formats in French

2011-10-28 Thread B.N.Chethan Kumar
Hi Kent, I have attached the file with custom format. Kindly check if these help. Regards Chethan Kumar BN On Fri, Oct 28, 2011 at 9:57 PM, HarryP Knuckles wrote: > Hi guys! > I have a quick question regarding formats. I have to > convert english accounting procedures into French a

Re: $$Excel-Macros$$ Extract from date and time

2011-10-18 Thread B.N.Chethan kumar
Hi, Lot of option you as suggested by many expert. if the data need to extract to 2 different formt.. Use below formualeInt( a1)Date and Mod(a2,1)---time...change the format of cell as required. Happy learning Regards Chethan Kumar BN On Tue, Oct 18, 2011 at 3:02 PM, Muhammad Arslan w

Re: $$Excel-Macros$$ Sum Product Sheet

2011-10-17 Thread B.N.Chethan kumar
Hi, Please find some more example on sum product. Regards Chethan Kumar BN On Tue, Oct 18, 2011 at 10:59 AM, ashish koul wrote: > http://www.bygsoftware.com/Excel/functions/sumproduct.htm > > http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/ > > http://www.exceluser.com/explore/sumpro

Re: $$Excel-Macros$$ Get the Unique value from pivot table in combo box

2011-10-17 Thread B.N.Chethan kumar
Hi, http://datapigtechnologies.com/blog/index.php/recordset-tricks-in-excel-1-filling-a-combobox-with-unique-values/ Hope these link help u better. On Mon, Oct 17, 2011 at 11:03 PM, ICWAI Help wrote: > Hello, > > I have a pivot table which is dynamic which is going to be change > every time whe

Re: $$Excel-Macros$$ Solution Request

2011-10-12 Thread B.N.Chethan kumar
Hi, Hope these help, Drag the file down untill last row of the data sheet. On Wed, Oct 12, 2011 at 6:40 PM, Ahmed Honest wrote: > Dear Mr. Shiek, > > Tons of thanks for your help. I hope that U achieved it by VBA but is there > any formula of excel to achieve this? > > Dear Mr. Don Guillet, >

Re: $$Excel-Macros$$ Excel is showing Error

2011-10-06 Thread B.N.Chethan kumar
Once i faced some issue. these happen because of comments updated in previous excel sheer from where data was copied.. i also not able hide columns. Select worksheet and remove comments (excel 2007 steps) Removing Comments from All Cells 1. Open the sheet with the comments to be deleted

Re: $$Excel-Macros$$ Need a help -----very urgent

2011-10-06 Thread B.N.Chethan kumar
t testing the previous one. >> >> >> Regards, >> >> Sam Mathai Chacko (GL) >> >> >> On Thu, Oct 6, 2011 at 10:57 AM, Sam Mathai Chacko >> wrote: >> >>> Range("A3:A6").TextToColumns Range("A3"), 0, 1, False

Re: $$Excel-Macros$$ Need a help -----very urgent

2011-10-05 Thread B.N.Chethan kumar
problem. > > ** ** > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *B.N.Chethan kumar > *Sent:* Wednesday, October 05, 2011 9:50 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Exc

Re: $$Excel-Macros$$ Need a help -----very urgent

2011-10-05 Thread B.N.Chethan kumar
quot;&MID(A3,FIND(" ",A3)+1,3)&"/"&RIGHT(A3,4)) > > Regards, > > Sam Mathai Chacko (GL) > > > On Thu, Oct 6, 2011 at 10:20 AM, B.N.Chethan kumar < > chetankumar1...@gmail.com> wrote: > >> Hi All, >> >> I have attached f

$$Excel-Macros$$ Need a help -----very urgent

2011-10-05 Thread B.N.Chethan kumar
Hi All, I have attached file where i get some data in text format. I need convert to date and time format. Currently using text to coloumn method which is manually pocess. As sheet count is high in a workbook, these is very painful work to do in month end. Kindly request your help to very painf

Re: $$Excel-Macros$$ How To Add A Year Field to a PivotTable Field List

2011-10-03 Thread B.N.Chethan kumar
Hi, you have option to group the file...Bring the data in excel pivit..and right clickselect group...and select group by year.. you can also group my month & Quarter too.. Regards Chethan Kumar BN On Tue, Oct 4, 2011 at 1:32 AM, John A. Smith wrote: > Attached is a spreadsheet from th

Re: $$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times)..

2011-10-02 Thread B.N.Chethan kumar
congrate mate On Sun, Oct 2, 2011 at 8:40 PM, NOORAIN ANSARI wrote: > Dear Group, > > Our Group Manager Mr. Ayush Jain has been awarded the Microsoft MVP award > for the 2nd year in row... > > Congrate Ayush > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com

Re: $$Excel-Macros$$ Incremental Time Calculation from 11:30:00 AM Time Format

2011-09-29 Thread B.N.Chethan kumar
(d2-c2)*24*60 ...change format to number Regards Chethan Kumar On Fri, Sep 30, 2011 at 1:36 AM, dguillett1 wrote: > =(D2-C2)*24 > > *From:* John A. Smith > *Sent:* Thursday, September 29, 2011 2:55 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Incremental Time Ca