Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging Excel Files
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging Excel Files
Hi Lupe
Try to look at it this weekend This is the page Lupe try to use http://www.rondebruin.nl/fso.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Lupe" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging Excel Files
Hi Lupe
Sorry I can't reproduce your problem at home on my network Maybe your IT department can help you -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Lupe Try to look at it this weekend This is the page Lupe try to use http://www.rondebruin.nl/fso.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Lupe" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging Excel Files
Hi Ron,
What you are telling me is that it should work. I'll check with our IT department and I'll keep you posted. Thanks again, because your macro helped me a long way. Regards, Lupe "Ron de Bruin" wrote: Hi Lupe Sorry I can't reproduce your problem at home on my network Maybe your IT department can help you -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Lupe Try to look at it this weekend This is the page Lupe try to use http://www.rondebruin.nl/fso.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Lupe" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merging excel files | Excel Discussion (Misc queries) | |||
Combining Excel files into 1 (no merging) | New Users to Excel | |||
Merging 800 Excel files | Excel Discussion (Misc queries) | |||
Merging Different excel files into one | Excel Discussion (Misc queries) | |||
merging my excel files | Excel Discussion (Misc queries) |