07-02-2013 04:07 PM
Hello Everyone
I am using LV 2010. It can be using the report generation toolkit or not.
Any help is appreciated.
xxxMidna19
Solved! Go to Solution.
07-03-2013 04:47 PM
Hi Midna,
I haven't been able to find any examples that accomplish this. We have a community example for creating a hyperlink in a cell in Excel via Active X. In this implementation, you need to give the address as a string. In order to modify this to link to another cell, you would need to find out if ActiveX has a way to format an address to another cell as a string. This should be standard to ActiveX.
I'm not sure that this will be possible to implement using ActiveX controls in LabVIEW, but I suggest you try starting with Microsoft documentation for ActiveX for Excel.
I hope this helps!
07-05-2013 01:22 PM
Hi Emily C.
Thanks for responding!
I want to modify this VI and hyperlink from the cell to another worksheet inside the same file. Is there a way to do this? I feel like you just neek to change
the invoke node under hyperlinks but I really don't know.
xxxMidna
07-08-2013 11:32 AM
Hi Midna19,
I have not been able to find any documentation or examples for accomplishing this. If there is a way to do this, it would be through standard ActiveX functions. I suggest you try starting with Microsoft documentation to find out if there is a way to use ActiveX to create a hyperlink to a cell in a worksheet. If there is a way to do this through Excel, you should just need to determine the right format to be able to modify this to connect from LabVIEW.
Thank you,
07-08-2013 01:34 PM
This works for me (I edited the VI in the link provided by Emily-C):
One way to figure out how to program something in Excel is to record a macro while manually doing what you're trying to accomplish programmatically. Here's the macro that resulted when I created a hyperlink to a cell in the same document:
Sub Macro1()
'
' Macro1 Macro
'
'
Range("A9").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Sheet2!A5", TextToDisplay:="Recorded"
End Sub
This clued me in to the fact that the Address needed to be an empty string and the SubAddress should be the Sheet!Cell of the target.
07-10-2013 11:14 AM
Thank you jcarmody! 😄
I have been trying to figure out this for a while now.
It worked and thanks also for the intro to Macro. I had no idea how to go about it.
xxxMidna