but i'm calling the macro from a c# application so i need to send an
argument with my command to run the macro, my line that runs the macro
is this
RunMacro(excelApp, new Object[]{"'[excel file
name]'!ActiveSheet.ActiveSheet"});

so i'm trying to figure how to send the argument from that line

Harald Staff wrote:
Sure. Include what you want inside its parentheses:

Sub test()
Call ")
Call ")
End Sub

Sub emailer(ToWhom As String)
MsgBox "mailing to " & ToWhom
End Sub


HTH. Best wishes Harald

"tommy" skrev i melding
...

i have an application that wrote and i need to pass a string
representing an email address to my macro so it knows who to send to,
can you pass an argument to a macro?