View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Przemek[_2_] Przemek[_2_] is offline
external usenet poster
 
Posts: 9
Default VBA- how retrieve source dir for the template *.xlt file ?

welcome.


I have a template file test.xlt existing in some dir other than excel
templates dir.
When the file is launched new workbook is created and i want to autosave it
in a dir
where the test.xlt file exists.
Due to fact that instance of the file test.xlt does not longer exists i cant
get source dir.

I would be thankful for any hint.

PS.
i have used a tip that every single file launched makes its mark in a
windows recent directory,
so i found a link file (test.xlt.lnk) but a dont know how to retrieve target
dir from it.
Maybe this way ?