filename = ThisWorkbook.Path & Application.PathSeparator & "TestImportFile1.xlsx"
filename = "C:\Users\John Smith\Desktop\Test import file\DifferentFolderf\TestImportFile2.xlsx"