Delay-loading the CLR in Office Add-ins

re: Delay-loading the CLR in Office Add-ins

andreww — Thu, 21 May 2009 09:41:33 GMT

gregc - it looks like you got an answer to your forum post. Just for completeness, the main problem was that your CommandBarButton.OnAction needed to be set to "!<ProgId_of_your_add-in>" - and it looks like you were'nt using the correct ProgId string value.

re: Delay-loading the CLR in Office Add-ins

gregc — Wed, 13 May 2009 18:19:01 GMT

Andrew, Can you give me an idea of what is required to hook up the event handlers correctly in order to make this work or what some of the common mistakes are? Some sample code would be great.

I posted a question on this to the VSTO forum that has some more detail.

http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/ee959b22-5a19-4afc-8895-ace32c3d0a22

re: Delay-loading the CLR in Office Add-ins

andreww — Wed, 13 May 2009 02:25:18 GMT

gregc - I never got a final response from Andrew, but not hooking up event handlers correctly is a common problem.

The comment that was cut off was a trackback (these are always cut off, because they only show the beginning of the trackback post). The post that included the trackback is here: http://blogs.msdn.com/andreww/archive/2008/07/14/demand-loading-vsto-add-ins.aspx

re: Delay-loading the CLR in Office Add-ins

gregc — Tue, 12 May 2009 22:29:49 GMT

Andrew,I am very interested in the resolution of the discussion just above but your last post is cut off.

Demand-Loading VSTO Add-ins

Andrew Whitechapel — Tue, 15 Jul 2008 06:27:13 GMT

In an earlier post , I talked about how you could delay (or prevent) the loading of managed code using

re: Delay-loading the CLR in Office Add-ins

andreww — Sat, 17 May 2008 07:45:42 GMT

Andrew - that should work. Are you sure you're hooking up the Click handler every time?

re: Delay-loading the CLR in Office Add-ins

Andrew — Wed, 07 May 2008 02:58:29 GMT

Forgot to say explicitly...yes, my managed add-in has a custom toolbar. So I want the first click on one of the buttons in the managed toolbar to load the add-in.

re: Delay-loading the CLR in Office Add-ins

Andrew — Wed, 07 May 2008 02:57:04 GMT

I'm trying to avoid writing the native add-in. So I'm just relying on the 'demand-load' flags in the LoadBehavior setting. I was hoping that would cause my add-in to load on the first button press.

I discovered that this works fine for the 2007 version of my add-in, but not for 2003.

re: Delay-loading the CLR in Office Add-ins

andreww — Wed, 07 May 2008 02:29:32 GMT

Andrew - it's not clear what you're doing. Is it that you followed the explanation in my post and you have a native add-in with a custom toolbar that activates your managed add-in?

Or, is it that you have only a managed add-in with a custom toolbar, and that you're relying on the inherent 'demand-load' LoadBehavior setting?

re: Delay-loading the CLR in Office Add-ins

Andrew — Thu, 01 May 2008 20:40:34 GMT

Thanks for the article! I'd been wondering if this was possible.

I'm able to get my toolbar to show up in Excel 2003 without the CLR loading on start-up (after changing the temporary argument to false when creating it), but it doesn't seem to be loading when I click a button.

Do I need to change something else in my add-in to get the demand loading to work?