Creating Hyperlink to another cell on the workbook

[IdoZe]

Hi,

I'm writing an Excel file, and want to add an hyperlink to a cell in another sheet in the current workbook.

When doing it normaly with the Excel application this type of link is called "Place in this document". However when I create the Hyperlink using the CVI Excel Report the link is created but does not function (I get an error). the address I use in the Hyperlink is :

'SHEETNAME'!A1

What am I doing wrong? maybe it can be done using the Excel 9.0 ActiveX package?

thanks,

Ido

[AEDavid]

Hi IdoZe,

This question seems to be more of a Microsoft Excel ActiveX question than a CVI question.  I would post this question on an MSDN forum.

For an example of creating hyperlinks in CVI, see how can i put HyperLink into exel throgh CVI.

Here is more help with the Excel ActiveX API hyperlink call.

Finally, a workaround might be to create a macro that makes a link, and call this macro using ActiveX (see the excel2000dem.prj in the Example Finder).