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.