ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   prevent all addin loads on start? (https://www.excelbanter.com/excel-programming/336386-prevent-all-addin-loads-start.html)

Vacation's Over

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


Vacation's Over

prevent all addin loads on start?
 
NEVER MIND............
now I see that although boxes are checked, nothing is loaded when opened
with automation..


"Vacation's Over" wrote:

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



All times are GMT +1. The time now is 01:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com