I have written a C# application using VS2005.NET to generate an Excel spreadsheet. My first worksheet contains an index to the other worksheets and I want to autogenerate a HyperLink using my C# application from cells in the first worksheet to the other worksheets.
I have seen many examples of linking to a web page and have done this using something like this:
",Type.Missing, Type.Missing, "Hyperlink Test");
The problem I have is I'm not sure how to reference a worksheet in the same Excel file.