I am trying to import a sheet from one excel file into a new file.
I created the below to accomplish this saving it into "PERSONAL.XLSB"
When I execute the code, I keep getting:
Run-Time error '1004':
Copy method of Worksheet class failed
I am able to open the sourceworkbook as expected, but...