PDA

View Full Version : saving changes to xlt doc



mferrisi
05-14-2008, 03:58 PM
I have an xlt file that is saved in a folder. It is used to create the xls docs in the code. I need to make a change to the template, but simply making a change and saving over the xlt document doesn't seem to work. Am I missing something? Thank you!

tplName = "v:\data\import.xlt"
Set wb = Workbooks.Add(tplName)

lenze
05-15-2008, 01:54 PM
Hi:
I believe you can right click the .xlt file icon in the folder and choose open. This should open the orignal template. Make your changes and resave.

lenze