View Single Post
  #5   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 ?


I don't have enough info to give good reults. Give more details.


the template file test.xlt HAS NO CODE, i cant give U more details bcoz
there are no details.

after launching XLT file it creates a copy of itself named "test1.xls".
Thats how template files works.
Unfortunately this copy of xlt file isnt saved,
and i need to save it into a directory where the source file "xlt" exists.

But the problem is "how to obtain the source dir".

PS.
Just create an EMPTY *.xlt file. Close Excel. And double click on the
created file.
U will se what i'm talkin ab.