Macro that puts data back in original excel spreadsheet

  • 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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!