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.
|