View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vacation's Over Vacation's Over is offline
external usenet poster
 
Posts: 279
Default prevent all addin loads on start?

I have an addin that opens a new instance of excel with a template workbook.

to prevent problems with user environment (other addins) I would like the
new instance of Excel to open without any addins. of course then I would load
my own addin in this "clean environment"

Thanks

code for new instance:
dim xl as object
Set XL = CreateObject(, "excel.application")
XL.Visible = True
XL.Application.Workbooks.Open (mytemplate)

template has :
XL.Application.IgnoreRemoteRequests = true