How to insert Hyperlinks in MS Excel using report generation toolkit ?

[leo22]

Does anyone know how I can insert hyperlinks in MS Excel worksheet from Labview 7.0 using report generation toolkit.

I am generating the path of the file to be opened in my program and want to store it as a hyperlink in Excel worksheet.

[Michael_Munroe]

Without writing your own function, your best bet is running a macro using the Excel Run Macro.vi. You can insert the code into your template workbook, another open workbook, or import the code at runtime using the Excel Import Module.vi.

Here is the code you will need:

Sub AddHyperlink(strLoc As String, strAddr As String, strText As String)
Range("strLoc").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, _
Address:="strAddr", TextToDisplay:="strText"
End Sub

Then place the three parameters in an array and wire to the parameters input.

Michael Munroe
Certified LabVIEW Developer
www.abcdef.biz