Hi,
I have succeeded to merge several excel files in a test environment. This is
on my own PC and network drive using Ron de Bruin's macro (Thank you Ron!).
However this must be used on another network drive where several other users
have their own subdirectories to work with. I have changed the path as
suggested but it does not work. Only when I give the name of the subdirectory
it picks the data from that subdirectory. I have set subfolders to True.
My statement works: RootPath = "\\islasrv02\Social\zone5"
My statement does not work: RootPath = "\\islasrv02\Social\"
In addition to zone 5 their are 6 other zones (=directories).
Any help is appreciated. Regards, Lupe