Macro to pull in files from folder that is unknown

Hi,

I'm currently running a macro that is importing and copying it's files from a set location. However, I'd like the macro to ask for the file location from where the .xls files should be pulled from, instead of this being a set dir. I've looked in various posts of the forums, but haven't found a solution to fit the specific case. For the rest of the macro I've made use of a previous post, and it works great.

Any help will be really appreciated!

Thanks
Sean

Please Login or Register  to view this content.

Hi,

This works like a charm, really appreciate the help on getting this solved. Will mark as solved!

THANKS!
Sean