Wow! Thanks for the quick reply CK!

This looks like it will work fantastically... I have just a couple of easy for you questions ...

How do I get excel to open a file based on the variable path and variable file name?

Do I even need to open the file to copy contents from it?

Thanks again!