Hi,
I have this macro which merges excel file data contained in one particular directory, its working fine there! However, I have several of these directories and I want this macro to perform the similar operation in all directories. So, normally I run this code folder by folder, now I want it to run in one folder and move automatically to next folder and do the same operation (merge all the excel files present there! How will it be possible? Can you suggest me better ways? I found this code in the page of Ron de Bruin: http://www.rondebruin.nl/tips.htm
The code is here:
It'd be very very very helpful if you can get me a solution. Thanks!
Sanjeev
Bookmarks