Set path to a folder when macro starts

[sbidgol]

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!

[ranman256]

You MUST add the reference to the file dialog app in VBE menu, TOOLS, REFERENCES

Please Login or Register  to view this content.

[watersev]

hi sbidgol,

Please Login or Register  to view this content.

[sbidgol]

Watersev,

very clean solution! Thank you so much!

I assume folder2process is a string variable where the path will be stored. Right?

Also, what does .Show = -1 mean?

+rep

[watersev]

that is correct

[watersev]

Please Login or Register  to view this content.

means the user pressed OK button

[sbidgol]

Ok, thank you