Folder Dialog Box with Combine Files Code

Hello all,

I have the below code which combines files in a designated folder. I would like to have excel prompt the user to browse to the folder where the files are, rather than have the folder path hard coded. I have tried various ways but cannot get it to work. Can anyone assist? I would like to accomplish this without dramatically altering my exisiting code...since it otherwise works great. Thanks!

Please Login or Register  to view this content.

Hi John,

Yes I saw that website as well. In fact, I tried at no avail to integrate that code with mine. Maybe it's a case of not knowing how to plug it in (my VBA skills are beginner at best).