pass argument to macro

[tommy]

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?

 

[Harald Staff]

Sure. Include what you want inside its parentheses:

Sub test()
Call emailer("(e-mail address removed)")
Call emailer("(e-mail address removed)")
End Sub

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


HTH. Best wishes Harald

 

[Tommy]

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]

I don't think you can do that. Hopefully someone proves me wrong. Suggest
you try a C# newsgroup as well.

Apart from that, I do anything to avoid having separate apps running
separate pieces of code just to produce a single result. When I control Word
from Excel then Excel has all the code, and vice verca. A ping-pong of
macros would definitely cause trouble. So I suggest you try to do everything
from C# while you're there.

Best wishes Harald

 

[Tom Ogilvy]

http://support.microsoft.com/default.aspx?scid=kb;en-us;306683&Product=xlw
HOW TO: Run Office Macros by Using Automation from Visual C# .NET

see Case 1 in the sample code. It shows both with and without an argument.

--
Regards,
Tom Ogilvy

I don't think you can do that. Hopefully someone proves me wrong. Suggest
you try a C# newsgroup as well.

Apart from that, I do anything to avoid having separate apps running
separate pieces of code just to produce a single result. When I control Word
from Excel then Excel has all the code, and vice verca. A ping-pong of
macros would definitely cause trouble. So I suggest you try to do everything
from C# while you're there.

Best wishes Harald

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"});