working with xltm files with vba

[lcrosspt]

hi i need to open a xltm, edit some fields and closed it again without user interaction...
my problem is that every time i try open the file it opens a new file and not the template

the code i'm using is ...

Set Z = Workbooks.Open("C:temp/tmplte.xltm")

can somebody explain why the openbook code does a new instead of a edit...
and is there a different method so save it ?

Thanks

 

[Fluff]

Hi & welcome to MrExcel.
try

Set z = Workbooks.Open("C:temp\tmplte.xltm", editable:=True)

 

[lcrosspt]

Thanks for the welcome and the help....
I just can´t believe it ... after reading several post about it.. it´s something so simple...
Thanks again!!

 

[Fluff]

Glad to help & thanks for the feedback