Dear Excel Experts,

I am trying to make a macro (in my personal macro workbook) that can export my adjusted data from an external source to the same folder as the external source. My workflow as follows:
Generate a text file from another software → Open a new excel workbook → "Get External Data: From Text" → Adjust the data → Save as Text Tab Delimited to external source folder

My previous macro to save as text doesn't work in this case, as it is directing the save to the directory of the active workbook and the workbook I'm using hasn't been saved anywhere.
My goal is to be able to save a new .txt file or overwrite the old one to the external source folder (which changes per project I'm working on), without needing to save the excel workbook itself.