how can i run excel/word macro to C# .net programs
 

i have macro in excel sheet in which data is sorted and some other functions.
i want to use that macro in C# .net
how can i use that.

how can i run excel/word macro to C# .net programs
 

What exactly doy ou mean by using the macro in C#.net? Do you want to
activate or run the macro in the Excel workbook from C#, or do you
want to use the functionality of the macro in your C# program?


On Oct 30, 8:04 am, Aaqib wrote:
i have macro in excel sheet in which data is sorted and some other functions.
i want to use that macro in C# .net
how can i use that.

how can i run excel/word macro to C# .net programs
 

yes, i want both
1) Activate and run the macro in the Excel workbook from C#,
2) Use the functionality of the macro in your C# program?
please answer whatever way you understand instead of re-asking. :(

" wrote:

What exactly doy ou mean by using the macro in C#.net? Do you want to
activate or run the macro in the Excel workbook from C#, or do you
want to use the functionality of the macro in your C# program?


On Oct 30, 8:04 am, Aaqib wrote:
i have macro in excel sheet in which data is sorted and some other functions.
i want to use that macro in C# .net
how can i use that.

how can i run excel/word macro to C# .net programs
 

You can use the Run method to run an existing macro. E.g.,

XLAppRef.Run "Book1.xls!TheMacroName"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Aaqib" wrote in message
...
yes, i want both
1) Activate and run the macro in the Excel workbook from C#,
2) Use the functionality of the macro in your C# program?
please answer whatever way you understand instead of re-asking. :(

" wrote:

What exactly doy ou mean by using the macro in C#.net? Do you want to
activate or run the macro in the Excel workbook from C#, or do you
want to use the functionality of the macro in your C# program?


On Oct 30, 8:04 am, Aaqib wrote:
i have macro in excel sheet in which data is sorted and some other
functions.
i want to use that macro in C# .net
how can i use that.