Double Click vs Open XLTM

[[email protected]]

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:

Please Login or Register  to view this content.

I ran of Ideas of what to do.

Thanks in advance.

Ernesto

[Norie]

When you double click a template file (xltm) you create a new workbook based on the template.

That new workbook won't really have a path until its saved.

Is the file meant to be a template?

[[email protected]]

I am trying to save the new XLSX where the Template is locate. Having trouble retrieving the Path Name; Looking into "FileSystemObject".

[Norie]

Ernesto

Do you actually want to use a template file?

[[email protected]]

I changed the file format to be XLSM; seems to work now, but I am having other issues, to be posted on another thread.

Thanks.

[[email protected]]

I am curious if there is a way to retrieve the correct Path for the Template (xltm) being run.

[Norie]

You could try CurDir.

[[email protected]]

That gives me the value in DefaultFilePath.

[Norie]

There is no built-in way/property to get the path/name of the template a workbook is based on.

Why do you want the path anyway?