X
XP
Using Office 2003 and Windows XP;
I need to use automation with late binding to open an Excel template (xlt)
for editing AND set its Addin property to false. The code I have so far, with
Tom Ogilvy's help is:
Dim oXL as Object
Dim oWB as Object
Dim sFullName = "fully qualified path to my file.xlt"
Set oXL = CreateObject("Excel.Application")
oxl.EnableEvents = False
Set oWB = oXL.Workbooks.Open(FileName:=sFullName, Editable:=True)
The problem is, since the template's Addin property is set to TRUE you get
an error that an addin cannot be opened for editing.
I suspect this is not possible, but if this is possible, could someone
please post example code and/or correct mine above to deal with it?
Thanks much in advance.
I need to use automation with late binding to open an Excel template (xlt)
for editing AND set its Addin property to false. The code I have so far, with
Tom Ogilvy's help is:
Dim oXL as Object
Dim oWB as Object
Dim sFullName = "fully qualified path to my file.xlt"
Set oXL = CreateObject("Excel.Application")
oxl.EnableEvents = False
Set oWB = oXL.Workbooks.Open(FileName:=sFullName, Editable:=True)
The problem is, since the template's Addin property is set to TRUE you get
an error that an addin cannot be opened for editing.
I suspect this is not possible, but if this is possible, could someone
please post example code and/or correct mine above to deal with it?
Thanks much in advance.