gpeterson69

Hi there,

I created an addin which has been loading fine up to now when I run it from VS2005 to test. The only problem I had before with it not loading was when my xml Ribbon was not formed well e.g. space in the id field. I've checked that and there is no problem there. (I used the custom UI tool to check the form) I had started to add code to my project to create an excel object so that I could transfer data that I successfully retrieved from another system to an excel sheet. The reason I mention this is I saw a Microsoft note possibly related to this where I have to add some code to force the call to the add in. Can this be correct Even if I comment out this code and rollback if you like it still will not load

When I go to excel options -> Add ins I can see my add in and it has been disabled. When I go to the Com add in screen and select it nothing happens i.e. if I go back in to the Com add in screen it is unchecked again

Any help would be greatly appreciated!

Thanks,

Grant.



Re: Visual Studio Tools for Office Addin not loading

Ji Zhou ¨C MSFT

Hi Grant,

Do you mean, you have no problem when run the project in Visual Studio IDE, but if installing it onto client machine, the issue occurs

The most potential reason of your scenario should be the security problem. When you install VSTO project onto client machine, to let it works, you should grant full trust to the Add In assembly.

You can use Caspol.exe to do that. Please refer the following link:

http://msdn2.microsoft.com/en-us/library/zdc263t0(VS.80).aspx

If you still have any question about the article, please feel free to let me know.

Thanks

Ji






Re: Visual Studio Tools for Office Addin not loading

gpeterson69

Hi Ji Zhou,

Thank you for getting back to me. I was having a problem while still developing the add-in. I was trying to re-enable the add-in by going via the excel -> options and selecting the com add-ins options in the drop down which listed the add-in. I could not then tick it to re-enable it.

I just found out if you select the disabled add-ins in the drop down rather you can then re-enable the add-in.

I'm sure I will make use of the info you provided above in future when I deploy!

Thanks once again,

Grant.





Re: Visual Studio Tools for Office Addin not loading

Ji Zhou ¨C MSFT

Hi Grant,

Yes, you are right. If you suffers this even when developing, the reason of it is that the Add in is hard disabled by Excel. This may caused from the Visual Studio Debugger is terminated unusually or a serious error in Start_up event handler terminated the Application.

You can get more information about this behavior in this link:

http://msdn2.microsoft.com/en-us/library/ms268871(VS.80).aspx

Thanks

Ji