VSTO application level add-in for Word

[DougB]

Hi,

I have what I thought was a very simple question but I'm stumped.

I have a very simple VBA macro for MS Word 2007 that I want to distribute
with a toolbar button to execute it.

It needs to have access to the current "activedocument" and cannot be
distributed in a document.

The code references things like the 'activedocument.selection.text' and the
'activedocument.content.find.hithilite'

My co-worker has previously developed add-ins that only referenced code in a
template. We are both stumped as to how to allow interaction with all
documents the application might load.

A number of websites seem to indicate that VSTO version 3 allows this (and
suggest it may have been taboo when VSTO first shipped) and/or there may be
hybrid solutions where install a trusted module of regular VBA Word code and
interact with it from our VSTO add-in but I don't see examples of either of
these.

Please help!

Thank you in advance.

--Doug B

 

[DougB]

Would the "EnableVbaCaller" functionality help here? If anybody can point me
in the right direction I'm willing to do the work. I'm under a tight
deadline and am really surprised that it is so difficult to distribute my
simple vba macro outside of a template.

Thanks!

--doug

 

[Manvir Singh]

I think "EnableVbaCaller" should be helpful in your scenario.

Also, you can refer to following Blogs/Articles:

1. Paul Stubbs : Extending VBA with VSTO 3.0

http://blogs.msdn.com/pstubbs/archive/2007/06/02/extending-vba-with-vsto-3-0
aspx
2. Office Apps: Extend Your VBA Code With VSTO
http://msdn.microsoft.com/en-us/magazine/cc163373.aspx
3. How Do I: Use the VSTO/VBA Interoperability Feature in a C# Project?
http://msdn.microsoft.com/en-us/office/bb879963.aspx

Hope this Helps!

 

[DougB]

Those articles seem to show these capabilities for "document level add-ins"
but this is an "application level add-in"

Can I really not do something as simple as write text to a Word document
from an application level add-in?

Please help, thanks!