<div>
katlin924,<br />
<br />
Your possible solution was helpful. &nbsp;As it turns out I was missing the apostrophes. &nbsp;Here is the line of code that worked for me:<br />
<br />
indexWorksheet.Hyperlinks.<wbr />Add(smsIng<wbr />redientRan<wbr />ge, &quot;&quot;, &quot;'&quot; + chartWorksheet.Name + &quot;'!A1&quot;, Type.Missing, smsIngredientCode);<br />
<br />
Thanks,<br />
<br />
Joe
</div>


<div>
Glad it worked. Happy to be of help. :)
</div>


<div>
<div class="content wysiwyg-content">
I have written a C# application using VS2005.NET to generate an Excel spreadsheet. &nbsp;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.<br />
<br />
I have seen many examples of linking to a web page and have done this using something like this:<br />
<br />
worksheet.Hyperlinks.Add(h<wbr />yperLinkRa<wbr />nge, &quot;<a href="HTTP:\\www.google.com" rel="ugc nofollow">HTTP:\\www.google.com</a>&quot;,Type.Missing, Type.Missing, &quot;Hyperlink Test&quot;);<br />
<br />
The problem I have is I'm not sure how to reference a worksheet in the same Excel file.<br />
<br />
<br />
<br />

</div>
</div>


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:

worksheet.Hyperlinks.Add(hyperLinkRange, "HTTP:\\www.google.com",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.





katlin924,

Your possible solution was helpful.  As it turns out I was missing the apostrophes.  Here is the line of code that worked for me:

indexWorksheet.Hyperlinks.Add(smsIngredientRange, &quot;&quot;, &quot;&#39;&quot; + chartWorksheet.Name + &quot;&#39;!A1&quot;, Type.Missing, smsIngredientCode);

Thanks,

Joe

Creating a HyperLink from a cell to a worksheet using C#

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:

worksheet.Hyperlinks.Add(hyperLinkRange, &quot;HTTP:\\www.google.com&quot;,Type.Missing, Type.Missing, &quot;Hyperlink Test&quot;);

The problem I have is I&#39;m not sure how to reference a worksheet in the same Excel file.





The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.