Dear all,

I have been trying to call a Macro from an addin, but it does not appear in the Macro-menu. Thus I cannot assign it to a tool bar button either. Can anyone help me??? I do need the file to be an add-in so I can't change that.

An how can I tell a VBscript to save the add-in in the default folder in stead of specifying a specific location?

Thanx alot in advance,

Chavo

Create a VBA routine to call the AddIn's routine.
That routine that you create can then be added to a toolbar button.

In the routine that you create, reference the AddIn specifically, and its routine. For instance, if the AddIn is called "BBR," and the routine is "GoPrint()," have your routine run the line BBR.GoPrint.

I haven't actually tried this, but it should work.

Pressing Ctrl+J in the VBA IDE should popup a list, and you can make your way through that list looking for the reference to the AddIn, to get the spelling, etc., right.