pass argument to macro

T

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?
 
T

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
 
H

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
 
T

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

Harald Staff said:
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

Tommy said:
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"});
Click to expand...
Click to expand...
 
Top