Hi Everyone,

I currently have some code that I would like changed, but I'm not too sure on how exactly to fix it. Here is the code:

Please Login or Register  to view this content.
As of right now, this code takes files and combines the worksheets into 1 worksheet. The folder path of these files is pasted in Cell A15 and then the macro picks up any file with "xl" in the file extension. What I'd like is for the user to be able to paste the filename in Cell A16 instead.

Could someone please take a look and see if they can make it so that the macro picks up the file where the folder path is in A15 and the filename is in A16?

Thanks in advance!