View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anand Nichkaode Anand Nichkaode is offline
external usenet poster
 
Posts: 53
Default 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.