So I've made enough progress in VBA to post this again. I'm trying to copy a sheet from another file in another folder. I can now make macros that copy data from another file within a file, but don't know how to copy the sheet when it's in another file.

Would someone modify this or say what code I should use?

The path for the other folder would be
"C:\Users\John Smith\Desktop\Test import file\DifferentFolderf\TestImportFile2"

Attached Files

MacroTest.xlsm (20.4 KB, 10 views)