I am trying to create a clickonce deployment for vsto. I am using Visual Studio 2008, Office 2007 and tools for office version 3.0.
I have created a certificate, signed the assembly and manifest and installed the certificate on the test client machine under the "trusted publishers" cert store.
The add-in loads however whenever I attempt to run any .NET code (instantiate a custom object for example) the addin crashes. By crashes I mean it disappears.
No security exception, no error message, nothing. I am certain it is not a bug in my code because it runs fine on the development machine. Does anyone have any experience with VSTO and clickonce deployment who could help me?

Thanks in advance for your thoughts.

---

FB

Well I figured out what the problem was, it was the fact that office doesn't load the VSTO addins to it's local applications folder when you do a click-once deployment from the network. It keeps all the executables remotely where ever you deployed your click-once application to. This means you need to add that location to your "trusted locations" in order for excel to execute anything that you have deployed there.

Thanks for you help everyone!

---

FB

I don't know what your add-in does, but can you put some messageboxes in it, or write to a log or something, so you can figure out exactly what's going on? Running from a dev machine isn't the same as running on a production machine (obviously).

Also, is the machine running any kind of virus protection? I found that no matter what I did, I couldn't enable an add-in to Outlook with Norton's Antivirus turned on -- it stopped all Office add-ins apparently.

RobinS.
GoldMail.com

---

Check out my blog at http://robindotnet.wordpress.com

Hi fbalas,

What add-in did you made? Word/Excel etc.?

If your add-in is for word, you can open MS word, click office button and click "word option", select the Add-Ins tab. At the bottom of that page, select Manage to "COM Add-ins" and click go. Can you see your add-in in the list? If you can find it, that mean the deployment is correct. There is some problem with the code and it is disabled by the office. You can put a try-catch in your code to raise error message in MessageBox.

Sincerely,
Kira Qian

---

Please mark the replies as answers if they help and unmark if they don't.

Well I figured out what the problem was, it was the fact that office doesn't load the VSTO addins to it's local applications folder when you do a click-once deployment from the network. It keeps all the executables remotely where ever you deployed your click-once application to. This means you need to add that location to your "trusted locations" in order for excel to execute anything that you have deployed there.

Thanks for you help everyone!

---

FB

Wow,that's weird. I haven't had that problem at all. Thanks for posting back with the answer!

RobinDotNet

---

Click here to visit my ClickOnce blog!