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.
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.
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