PDA

View Full Version : Opening a template in VBA



Gadget
01-16-2008, 05:32 AM
Any time I try to open a template file (.xlt) it generates a new file (.xls) - can someone tell me how? :think:

I've tried .open and .new

{I've got an input form where the user can add an item (row) into the current spreadsheet and it populates all the formulas with that row along with the data entered on the form.
I want to have an option to also add this item into the template that the user create their spreadsheet from... }

Bob Phillips
01-16-2008, 06:36 AM
That is what templates are, a template for a new file.

If you want to open it as a template, then use open, but set the Edit argument to True also.

Gadget
01-16-2008, 09:27 AM
Ahhhh - "Editable"... :D

thank you
~G~