Creating Hyperlink and Running Macro in Exel using C#

[a1jit]

hI gUYS,

 

i have 2 questions to inquire..

 

1) Lets say i want to create a hyperlink programatically using c#, HOW do i do it? Maybe i want to place a hyperlink in cells(1,1) linking to cells(1,3)

 

 

2) Is it possible to run an excel macro (placed in excel file) using c#..

Means that i open my application using c#, then i run the macro in the excel file from my c# application..How can i achieve this

 

Really appreciate it if some guidance can be provided ..thank you very much..

[a1jit]

Found a way to run macro..but still cant find solution for the first question

 

oXL.Run("TEST",Type.Missing,Type.Missing,Type.Missing,

Type.Missing,Type.Missing,Type.Missing,Type.Missing,

Type.Missing,Type.Missing,Type.Missing,Type.Missing,

Type.Missing,Type.Missing,Type.Missing,Type.Missing,

Type.Missing,Type.Missing,Type.Missing,Type.Missing,

Type.Missing,Type.Missing,Type.Missing,Type.Missing,

Type.Missing,Type.Missing,Type.Missing,Type.Missing,

 

Type.Missing,Type.Missing,Type.Missing);