$$Excel-Macros$$ Re: Help in MS excel

2009-09-15 Thread pradeep palande
Hi Chechu & all of the group members Thanks for your help.. I am really very new for this all macros and excel.. That would be great if you could help me to understand how to use this code. --Bunty On Mon, Sep 14, 2009 at 3:23 PM, Chechu wrote: > > Hi Bunty, > > Take a look to the followi

$$Excel-Macros$$ Re: Help in MS excel

2009-09-14 Thread Chechu
Hi Bunty, Take a look to the following code, might help. It opens each .xls in the same path where this file resides, and copy-paste predefined rows. Regards, Chechu Sub Macro1() Dim MyFile, MyPath, MyName, ThisFile, Location, PathFileTemp, Fila, ThisSheet 'On Error GoTo ErrorHandler ThisShee