Prompt User for Location of Files needed

[futebol23]

I want to create an excel file and code that asks the user for two locations of files to input, then my excel file does some comparisons and calculations of those two sets of files, and spits out a nice formatted comparison file. The part of the process I am struggling with right now is prompting the user for the two directories where the two sets of files are stored.

When the macro starts, I want a window to pop up that is similar to the window that pops up when you click the 'Open' button except a user selects a directory instead of a file. Once the user selects the location of the first directory, a second pop up which is the same as the first pop up would ask the user to choose the directory that is used to compare against the first. Let me know if this is possible or if there is a somewhat different method that has the same functionality. Thanks!

[royUK]

Try this

Please Login or Register  to view this content.

[futebol23]

Thank you for your help. After changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

I tried to run your code and received the following error: "Compile Error: Label not defined" regarding the line of code

Please Login or Register  to view this content.

I am not sure why this error occured and if this allows the user to select a directory.

[royUK]

Sorry, I didn't copy all the code

Please Login or Register  to view this content.

[futebol23]

Thanks. Is there a way to have the user select a directory as opposed to a file in a directory?

[royUK]

First you need to set a reference to the "Microsoft Shell Controls And Automation" object library. In the VBA Editor, go to the Tools menu, choose References, and scroll down to this item and put a check next to it.
Then, copy the following code to a standard code module:

Please Login or Register  to view this content.

You can the call the BrowseFolder function with the following code:

Please Login or Register  to view this content.