The easiest way is to:
a. Create a new Folder that is empty.
b. Put the file with the code in that folder
c. Set the path in the VBA code to:
SpecialPath = ThisWorkbook.Path & "\"
d. All the imported and exported files will be in the same folder.
e. After you're done, move your file to whatever folder you like.