Jump to content

Excel- adding hyperlink in different sheets


Recommended Posts

Hi friends,

                  I am developing a LV vi to create an excel test report. The excel contains two sheets-

 

1. Test summary

2. Test Results.

 

In the Test summary sheet, I need to create hyperlink to Test results cells. I am able to create hyperlinks on the same sheet or external files not to the " Test results" sheet. I dont know how to set address value of "Test Results" to  Hyperlinks property created with Anchor value referencing to Test Summary sheet. It is confusing. :throwpc:

  

post-16569-0-15250600-1431481738_thumb.j

 

 

When I click Test Link , y control should go to Test Results field.  :rolleyes:

post-16569-0-28968700-1431481584_thumb.j

Link to comment

Glad you found the solution, but what I would have suggested, is to open Excel, then have it record a macro, then create the link manually in Excel, and then look at the text that the macro generated.  The VBA code generated from a recorded macro can be translated into LabVIEW code by calling the same ActiveX calls.  Some times there is difficulties in translating it, and some function calls accept various values and the macro will only show you the one way that worked.  But it is a great tool for understanding what chain of calls is needed to get a function to work the way you want.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.