Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / Visual Studio.NET / VS Tools for Office / July 2008

Tip: Looking for answers? Try searching our database.

I need instructions on removing an Excel VSTO 3.0 Add-In

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gary Rynearson - 23 Jul 2008 18:49 GMT
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 :-)

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.