Hi,
I am trying to append multiple excel workbooks into. Basically to
merge daily reports into a weekly one.
I found the code below somewhere on internet but it is not working for
me.
Can someone please look and let me know how I need to change this in
order to make it work ?
Sub AppendData()
e also assumes that the format of your weekly
> report is identical to the format of the daily reports. Is that the
> case?
>
> On Oct 1, 12:43 am, suyog_linux wrote:
>
>
>
> > Hi,
>
> > I am trying to append multiple excel workbooks into. Basically to
> >
; 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 w
