Macro to Save as Text to External Data Source Directory

[Baiano42]

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.

[NoSparks]

My previous macro ???

How are you able to → "Get External Data: From Text" → without the path to it?

[Baiano42]

So this was the macro I had been using to save as text before:

Option Explicit

Sub SaveSheetToTxt()
'UpdatebyBaiano42
    Dim xRet As Long
    Dim xFileName As Variant
    Dim wbText As Workbook
    On Error GoTo ErrHandler:
    ChDir ThisWorkbook.Path                
    xFileName = Application.GetSaveAsFilename(ActiveSheet.Name, "Text (Tab Delimited) (*.txt), *.txt", , "Kutools for Excel")
    If xFileName = False Then Exit Sub
    If Dir(xFileName) <> "" Then
        xRet = MsgBox("File '" & xFileName & "' exists. Overwrite?", vbYesNo + vbExclamation, "Kutools for Excel")
        If xRet <> vbYes Then
            Exit Sub
        Else
            Application.DisplayAlerts = False
            Kill xFileName
            Application.DisplayAlerts = True
        End If
    End If
    ActiveSheet.Copy
    Set wbText = ActiveWorkbook
    wbText.SaveAs xFileName, xlUnicodeText
    wbText.Close False
My_Exit:
    Exit Sub
ErrHandler:
    MsgBox Err.Description, , "Kutools for Excel"
End Sub

The problem with this code is that it is set to save to "ThisWorkbook.Path". Which, as the WB has not been saved anywhere, it does not have a path to reference to. (See attached images for further reference).

So I do have the 'path' in a sense. However, as I am constantly building new projects, I'm trying to make the macro be able to direct the new .txt document save to the current external source document I have sourced to the WB.