$$Excel-Macros$$ Re: Lotus Notes * Delivery Failure*

2008-09-02 Thread Alokeshwar Tiwary
why do u need a macro for the same? simply set a filter to delete all such messages.. _ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, ther

$$Excel-Macros$$ Re: Lotus Notes * Delivery Failure*

2008-09-02 Thread Alokeshwar Tiwary
why do u need a macro for the same? simply set a filter to delete all such messages.. _ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, ther

$$Excel-Macros$$ Re: Vlookup Help

2008-09-02 Thread rishi dakalia
Thanks a lot atul. it was really helpful On Thu, Aug 28, 2008 at 10:49 AM, SINGHAL, ATUL. <[EMAIL PROTECTED]> wrote: > Hi Rishi, > > The formulae in the enclosed file may help you. > > Regards > Atul > > > -Original Message- > *From:* rishi [mailto:[EMAIL PROTECTED] > *Sent:* August 26,

$$Excel-Macros$$ Re: Arrays

2008-09-02 Thread Pankaj Jaitly
Hi, I need to store a table in a an array and thereafter lookup values from it. Can anybody tell me how can i use this. Also the values in the table would be dynamic based on certain calculation. Can anybody help. I am putting a file with calculations , i need to do this in VB so that only result

$$Excel-Macros$$ Re: Suppress Excel containing Macros while opening MS excel

2008-09-02 Thread STING
Hi You would want the macro to run at the backend but donot want the screen to update . Start the procedure with : Application.Screenupdating = False End the procedure with : Application.Screenupdating = True Sting On Aug 31, 10:25 pm, "swapnil somkuwar" <[EMAIL PROTECTED]> wrote: > Hi Folks, >

$$Excel-Macros$$ Re: Importing data in one spreadsheet into a certain area on another spreadsheet

2008-09-02 Thread Alokeshwar Tiwary
Att. [EMAIL PROTECTED] Can you please send the files for example? Regarding the file name change issue you can modify following code to variable FileName whereever your want.   Sub GetFileName() Dim FileName As String Dim Msg As String FileName = Application.GetOpenFilename Msg = "You selected: "

$$Excel-Macros$$ Lotus Notes * Delivery Failure*

2008-09-02 Thread STING
Hi , I have an automated report which goes out to 500 users at a time via lotus notes . Problem: Delivery failure mails eating up the the inbox space What is the code I need to enter in my Macro to stop receiving delivery failure reports /mails for the same report . Thanks Sting --~--~---