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