How to access a function stored in Add-In

Hello All,

I would like to invoke functions stored in Add-ins from a macro. Can anyone provide me a method or solution to achieve the same. I already installed that Add-in and it is also visible in the project explorer. But I just want to know whether I need to give any declaration or sort of to access its functions.

Thanks in Advance


Listserv Archives (BOB member since 2002-06-25)

You must add your add-ins in the VBA references (tools/References). Then the syntax is:

Sub main()
Call ProjectName.ThisDocument.ProcName(arguments) End Sub

Christophe

Hello All,

I would like to invoke functions stored in Add-ins from a macro. Can anyone
provide me a method or solution to achieve the same. I already installed that Add-in and it is also visible in the project explorer. But I just want
to know whether I need to give any declaration or sort of to access its functions.

Thanks in Advance

Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
Web archives (24 hrs. a day now!): listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’


Listserv Archives (BOB member since 2002-06-25)

I got it. Thanks for the response.

JP


Listserv Archives (BOB member since 2002-06-25)

Are you using it with BroadCast Agent ?

Christophe

I got it. Thanks for the response.

JP


Listserv Archives (BOB member since 2002-06-25)

Yes, I have planned to use with BroadCast Agent. Currently we are in BO 4.1.5 and using some scripts in DAS. I would like to migrate them to use with BroadCast Agent. But I have preferred to use the following syntax to call a procedure stored in Add-In.

Sub Main()
Application.ExecuteMacro “CommonFunctions.rea!Procedure(argument)” End Sub

’ Where “CommonFunctions.rea” is the Add In File name

JP


Listserv Archives (BOB member since 2002-06-25)