SOLVED - and it was a simple mistake. I set the macro to open instead of import, so it was creating a new file instead of staying in the one I wanted.
I have a Excel workbook with multiple sheets and a macro that opens and formats at txt file, but it doesn't bring the data back into my spreadsheet - it opens a new text file. I thought I could copy the data and paste it back top my spreadsheet, but I can only get as far as coping. I cant seem to find a way to paste it back. My original file name is MAX.xlsm and the sheet I want populated is Sheet1