$$Excel-Macros$$ Outlook Mails log in Excel through MACRO

2014-06-10 Thread Rohan Young
Hi Group, I have two folders of mails (incoming outgoing) and I need a macro to make a log of mails separately of both folders in excel with the following details From, To, CC, Subject, Date, Time Please do the needful ASAP Rgds ROHAN 9818247278 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

$$Excel-Macros$$ BANKING APPLICATION

2014-06-10 Thread Shankar Bheema
Hai Friends Pleas guide me and refer any site which is having sample EXCEL VBA applications in the retail banking sector. I am very thankful to one and all. regards shankar sb -- 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

Re: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO

2014-06-10 Thread Rohan Young
Hi, Thanks Anil Ravinder but I need to make log in Excel with details of To, From, CC, Subject, Date, Time etc. and all data of Outlook mails is saved in Hard Drive with the name of Incoming Outgoing. please look at output sample : *To* *CC* *From* *Subject* *Date Received* *Time of mail*

Re: $$Excel-Macros$$ How to pause the Excel VBA macro at certain point and then start again

2014-06-10 Thread Paul Schreiner
I'd try a combination of the Application.Wait and a loop to check to see if the download file is ready. Depending on file size, I'd probably check the size of the download file. then wait for 5 seconds, and check again. If the file size changes, then wait again until the file size no longer

Re: $$Excel-Macros$$ Run time error 9 subscript out of range - lotto Query

2014-06-10 Thread Will Sob
thanks it did work but it did not build the triplets i specify it just calculated it to 18424 On Tue, Jun 10, 2014 at 6:19 AM, Vaibhav Joshi v...@vabs.in wrote: Here you are declaring Dim tbl(1 To ntbl, 1 To 2) As Long when vale of m drops belwo 1 you will get error 9 change lines to..

RE: $$Excel-Macros$$ How to pause the Excel VBA macro at certain point and then start again

2014-06-10 Thread Ravinder
Did you try below code for waiting browser. Do while browser.busy or browser.readystateREADYSTATE_COMPLETE Doevent loop From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sukanta Datta Sent: Tuesday, June 10, 2014 7:39 PM To:

RE: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO

2014-06-10 Thread Ravinder
U want to save exl files with name or outlook mails in incoming and outgoing folders? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rohan Young Sent: Tuesday, June 10, 2014 4:55 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$

Re: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO

2014-06-10 Thread Rohan Young
Hi Ravinder, I want to save a excel file like logbook of Incoming Outgoing mails with details as stated before no need of msg body Thanks On Wed, Jun 11, 2014 at 10:16 AM, Ravinder ravindervbacli...@gmail.com wrote: U want to save exl files with name or outlook mails in incoming and

$$Excel-Macros$$ Repeat Header Rows in prints upto initial selected sheets

2014-06-10 Thread Rohan Young
Dear Group, I need a UDF for repeat header rows in prints upto selected sheets (i.e. initial 5 or 6 no. sheets) after that no need to print header rows on remaining sheets. Thanks in advance ROHAN -- 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)