I have a macro to extract data from an Excel tab and reformat the data and write each line to a "TXT" file.
Previously the code was written to read a CSV file, but I have changed it to read from the current worksheet tab.
I was wondering how to name the correct import path for the sheet.
Here is the original code for the CSV file.
I have attached the code for the Start and Import Macro.