Executing a Com-Add in from Within Publisher VBA

[jasonp128]

I'm sure I'm missing a really easy step on this but it's eluding me. I have
a com add-in installed in publisher that I would like to execute at the
beginning of a procedure I'm running. I have been able to find the com
add-in info within my VBA code using the Application.COMAddIns.Item(#).etc...
but I can't seem to execute the add in. Any help would be much appreciated.

Thank you very much for taking a look and your help.

Jason

 

[Ed Bennett]

I'm sure I'm missing a really easy step on this but it's eluding me. I have
a com add-in installed in publisher that I would like to execute at the
beginning of a procedure I'm running. I have been able to find the com
add-in info within my VBA code using the Application.COMAddIns.Item(#).etc...
but I can't seem to execute the add in. Any help would be much appreciated.

I'm not sure what you mean by "execute" the add-in. An add-in loads at
startup if it is installed; the add-in's methods occur when they are
triggered (either by events or externally).

If you want to call the add-in's methods from VBA, then you need to use
the COMAddIn.Object property. This must be set from within the add-in
(most simply to the add-in itself, using something along the lines of
AddinInst.Object = Me
).

I haven't ever needed to do this myself, so am going on the basis of
what little I can find online.
http://www.bokebb.com/dev/english/1990/posts/199084229.shtml is one
piece of information I found.

 

[jasonp128]

Thanks for your Reply Ed. After looking through this I realized that I was
making it far more difficult that it needed to be. The com add-in has a
button on the task bar in Publisher which I can call directly and execute
which worked perfectly. Thank you again for your help

Jason

 

[dev man 2009]

I also found the simple method below
Also, please refer to these links for more information:

http://www.msdns.org/archive/1990/posts/199084229.shtml
is the piece that I found.

 

[dev man 2009]

http://www.msdns.org/archive/1990/posts/199084229.shtml

hope This link maybe help you!