How do you open a template itself with the same .xlt filename for editing? I tried:
Workbooks.Open Filename:= _
"C:WINDOWSApplication DataMicrosoftTemplatesJasper Template.xlt", _
Editable:=True, Format:=xlTemplate
But that Format option wasn't correct...
The Add method below does indeed open the template with a different filename ("Jasper Template1.xls" and workbook format:
Workbooks.Add template:= _
"C:WINDOWSApplication DataMicrosoftTemplatesJasper Template.xlt"
Since I'm still pretty new to this great forum, here's a posting question: When posting, how do you refer/link to a previous post? This one was related to a previous post of mine, which I could have just linked to...
Thanks again!
Workbooks.Open Filename:= _
"C:WINDOWSApplication DataMicrosoftTemplatesJasper Template.xlt", _
Editable:=True, Format:=xlTemplate
But that Format option wasn't correct...
The Add method below does indeed open the template with a different filename ("Jasper Template1.xls" and workbook format:
Workbooks.Add template:= _
"C:WINDOWSApplication DataMicrosoftTemplatesJasper Template.xlt"
Since I'm still pretty new to this great forum, here's a posting question: When posting, how do you refer/link to a previous post? This one was related to a previous post of mine, which I could have just linked to...
Thanks again!