Quote:
Originally Posted by p45cal
try changing:
Code:
filename = ThisWorkbook.Path & Application.PathSeparator & "TestImportFile1.xlsx"
to the likes of:
Code:
filename = "C:\Users\John Smith\Desktop\Test import file\DifferentFolderf\TestImportFile2.xlsx"
|
Ok, so that worked, but this file will be used by others and kept in their folders under different user names. I tried something like;
filename = "C:\Users" & uzer & "\Desktop\Test import file\DifferentFolderf\TestImportFile2.xlsx"
And it did not work in my profile. The spreadsheet must be usable in other users profiles.