Hi,

I have been trying to figure this out, but without any success. I have a macro that goes into a specific folder and merges all excel workbooks in that folder. What I want to do is that the user should be able to choose the path of the folder with all the excel workbooks when the macro starts running.

Should be like this:
1)Macro runs
2)Dialog window pops up
3)User chooses what folder where the workbooks are
4)The path to this folder is stored in a string variable


Thanks!