Otherwise, you will need to provide some other way to get the FQ filename into your code. Documentation on this object can be found at: If you want to provide a way to choose the import file, You can work with the FileDialog Object. If it is in a different folder, you will need to provide the Fully Qualified path to the file and folder. That being said, when you reference a file from your macro, it will generally assume the file you are referencing is in the same folder as the Workbook where you launched the macro. I think people might find it a bit risky to download and open an Excel file that contains a macro. I suggest that you upload a text file of your macro rather than an *.xlsm file.
