View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default pass argument to macro

http://support.microsoft.com/default...83&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" wrote in message
...
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" skrev i melding
...
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"});