Macro get executed twice
Hi,
I have an add-in which I load in Excel by passing the add-in to Excel
command line.
The add-in opens a workbook does some work and then invokes a macro present
in the workbook as belows
Application.Run ("'" & RptObj.Name & "'!" & strMacroName)
I have observed that the Macro is invoked twice if the strMacroName has
macro name like Main() i.e. with parantheses.
But if strMacroName does not contain "()" parantheses then macro is invoked
once only.
Any idea what is happening or what I did wrong.
Thanks for any help in advance.
|