Create Hyperlink in Excel

[Toni]

Hi all,

I looked through the excel examples that ship with labview. I found out how to get data into excel cells and read from them. But I still look out how to create a hyperlink that is connected to a text in an excel cell. I think this could be done without using the report generation toolkit, that I don't have.

Best Regards,

Toni

[Joe_Guo]

Try to manual create a hyperlink and record the action in a macro. Modify the macro to a procedure with input parameters. Call this procedure in your code.

-Joe

[Toni]

Thank You Joe,

for your reply. I found the hyperlink in the property-node as attached. Unfortunately it is read-only and can't be set to write 😞

[Toni]

Ok,

now I got a little further into the problem.
I found the Visual Basic Help and tried the attached solution. I'm not sure how to interpret the Anchor field right. Unfortunately the piece of code isn't working.
Any ideas what's going wrong? Any help is appreciated,

Toni

[ank]

Dear Toni,

I too have been trying to do the same activity as described by you and am unsuccessful in it . Did you reach a solution for your issue. can you please educate me on that?

Thanks

Ankur Kumar

[F._Schubert]

I solved a similar problem that way:
* Use the Hyperlink Collection of the Worksheet (not Range as you do)
* Anchor is the Cell
* Adress is a named Cell in my case

Hope that helps, would be nice to have your solution as I will have to hyperlink external documents in the next time.

Felix

[Dipsy]

Hi All,

here is the solution for it.

i am able to put a hyperlink into excel now.

Hope this helps you.