$$Excel-Macros$$ Re: Appending multiple excel files into one

2009-10-03 Thread RolfJ
It's difficult to comment on this without seeing your whole code. Please post it and I promise to take a look, Rolf On Oct 2, 10:47 pm, suyog_linux wrote: > Hi Rolf, > > Thanks for responding. > > I made the changes as described. Now I am getting an error "Duplicate > declaration in current sco

$$Excel-Macros$$ Re: Appending multiple excel files into one

2009-10-02 Thread suyog_linux
Hi Rolf, Thanks for responding. I made the changes as described. Now I am getting an error "Duplicate declaration in current scope." for statement --> Dim path as string Please help. Suyog On Oct 2, 1:49 am, RolfJ wrote: > Got it. Try declaring fso this way: > >    Dim fso As Object >    Set

$$Excel-Macros$$ Re: Appending multiple excel files into one

2009-10-02 Thread RolfJ
Got it. Try declaring fso this way: Dim fso As Object Set fso = CreateObject("Scripting.FileSystemObject") On Oct 1, 10:34 pm, suyog_linux wrote: > Hi Rolf, > > Thanks for responding. > > Please find the answers below : > > 1. I am getting the error which says: >     "User defined type -

$$Excel-Macros$$ Re: Appending multiple excel files into one

2009-10-01 Thread suyog_linux
Hi Rolf, Thanks for responding. Please find the answers below : 1. I am getting the error which says: "User defined type - not defined" This error is related to first Dim statement in the code above. Dim fso As Scripting.FileSystemObject 2. Obviously it is critical that you

$$Excel-Macros$$ Re: Appending multiple excel files into one

2009-10-01 Thread RolfJ
You need to be a little bit more specific in HOW this code is not working for you. Obviously it is critical that you specify the range of cells you want to copy (in the code you showed it is set to "B28:F28". Is that correct? Also the code assumed that your daily reports contain the date you want