Have user pick folder to run script

Hi,
I have a script that runs through all the workbooks in a folder However the path is hard coded. What I would like to do is use part of the hard code path but have the user pick the last folder that contains the files the script would run on. I tried to use the application getopenfile but that only picks the file itself not the folder.

Can someone help me modify this line of code to have the user pick the last folder?

Please Login or Register  to view this content.

Here is the entire script if it's of any help in solving the issue.

Thanks For your help, Mike

Please Login or Register  to view this content.

Good afternoon realniceguy5000

Originally Posted by realniceguy5000

Can someone help me modify this line of code to have the user pick the last folder?

The GetOpenFileName instruction is great, but as you pointed out it's only useful for selecting a file, and there is no ready made instruction for selecting a folder.

That said, there is a piece of code kicking around the internet that will allow you to open and utilise a "Browse for Folder" dialog, which seems perfect for your needs. John Walkenbach includes the whole code, plus a brief write up here.

HTH

DominicB

You can use this too:

Please Login or Register  to view this content.