I have this XLTM that reads via sql some records from two files, and should save them in an Excel worksheet (XLSX) on two tabs, via

I am trying to retrieve the Path where the XLTM is located; and have the XLSX saved there.

If the XLTM is opened via double click. The Path is defined as the Default File Path (Application.DefaultFilePath) but this is NOT where the XLTM is really located. If I Open it via OPEN, the path is retrieved correctly:

  
Mypath = CurDir    ' This Retrieves the Def File Path 
MsgBox Mypath
  
ThisWorkbook.Save              ' Note ThisWorkbook.Path is always empty until saved
Mypath = ThisWorkbook.path    ' This returns the Correct Path if Opened via OPEN

' Mypath = CurDir

MsgBox Mypath
I ran of Ideas of what to do.

Thanks in advance.

Ernesto