I am using VS 2008 Professional with VSTO 3.0 and I successfully created a
trivial Excel 2007 Add-in that displays a diaog box ("Hello World!").
Now, whenever I load an Excel File (xlsx), it displays the dialog box. Can
anyone provide instructions on how I can load an Excel Workbook without
having the Add-in run?
Thanks
Gary
Gary Rynearson - 23 Jul 2008 19:33 GMT
Some help files at http://msdn.microsoft.com/en-us/library/ms268878.aspx
>I am using VS 2008 Professional with VSTO 3.0 and I successfully created a
>trivial Excel 2007 Add-in that displays a diaog box ("Hello World!").
[quoted text clipped - 5 lines]
> Thanks
> Gary
Gary Rynearson - 23 Jul 2008 20:29 GMT
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\ExcelAddIn1\LoadBehavior
set this value to 0 (from the default of 3.
This link has a description of all the values of loadbehavior and their
descriptions
http://blogs.msdn.com/andreww/archive/2008/04/19/delay-loading-the-clr-in-office
-add-ins.aspx
LB
Meaning
Status in COM Add-ins Dialog
Behavior Description
0
Unloaded
Disconnected, Unloaded
The add-in is not loaded when the application starts. It can be loaded
through the COM Add-ins dialog box or programmatically, but reverts to
"Unloaded" when the application closes.
1
Loaded
Disconnected, Loaded
The add-in is not loaded when the application starts (despite the status of
"Loaded"). It can be loaded through the COM Add-ins dialog box or
programmatically, but reverts to "Loaded" when the application closes.
2
Boot-Loaded
Disconnected, Load at Startup
The add-in is not loaded when the application starts. It can be loaded
through the COM Add-ins dialog box or programmatically. Once the add-in is
loaded, it remains loaded until it is explicitly unloaded, that is
LoadBehavior is set to 3, and this status is persisted in the registry
across sessions.
3
Boot-Loaded
Connected, Load at Startup
The add-in is loaded when the application starts. It remains loaded until
it is explicitly unloaded.
8
Demand-Loaded
Disconnected, Load on Demand
The add-in will be loaded and connected when the host application requires
it, eg, when a user clicks on a button that uses functionality in the
add-in, that is LoadBehavior is set to 9.
9
Demand-Loaded
Connected, Load on Demand
The add-in will be loaded and connected when the host application requires
it, eg, when a user clicks on a button that uses functionality in the
add-in.
16
Connect First Time
Connected, Load on Demand (currently loaded) The add-in loads as soon as
the application starts the first time after the add-in is registered.
Typically, the add-in creates a button or menu item for itself. The next
time the user starts the application, the add-in is loaded on demand (LB=8),
that is, it doesn't load until the user clicks the button or menu item
associated with the add-in. This sets the LoadBehavior to 9.
>I am using VS 2008 Professional with VSTO 3.0 and I successfully created a
>trivial Excel 2007 Add-in that displays a diaog box ("Hello World!").
[quoted text clipped - 5 lines]
> Thanks
> Gary
Cindy M. - 24 Jul 2008 15:47 GMT
Hi Gary,
> I am using VS 2008 Professional with VSTO 3.0 and I successfully created a
> trivial Excel 2007 Add-in that displays a diaog box ("Hello World!").
>
> Now, whenever I load an Excel File (xlsx), it displays the dialog box. Can
> anyone provide instructions on how I can load an Excel Workbook without
> having the Add-in run?
Open the Add-in in VS 2008. Run "Clean Build" from the Build menu. That will
un-register the Add-in.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)