Choosing folder path (instead of file path) in VBA

[sminter]

Hello,

I have a program in VBA that modifies other files that are within the same folder (using ThisWorkbook.Path). I would like to add a feature to the program that allows the user to select a different folder using a dialog box, so that files in other directories can be modified also. Something very similar to Application.GetOpenFilename would be ideal, but would allow me to select a folder instead of an individual file. Many thanks for any insight you can offer.

[jaslake]

Hi sminter

Perhaps this

Please Login or Register  to view this content.

[sminter]

Thank you for your reply. Upon executing your code, I got an error message saying "Object required." I've used objects once in the past, but I'm not sure how to set an object to work with this example. Just to try various modifications, I commented out the "Option explicit" line, and the object error disappeared, but I got a new error that said "Variable not defined," and highlighted the "application..." line in the "with" statement. I imagine that the first error is the one to focus on. Is there a way to add an object to your code? Thanks again.

[jaslake]

Hi sminter

It works for me...see attached.

[sminter]

Right you are, it must be something in my file interfering with it. When I start from scratch, it works like a champ. Thanks so very much!!