View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default Open XLT for edit and set Addin to False

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.