Drexel dragonThe Math ForumDonate to the Math Forum



Search All of the Math Forum:

Views expressed in these public forums are not endorsed by Drexel University or The Math Forum.


Math Forum » Discussions » Software » comp.soft-sys.matlab

Topic: changing Hyperlink text with activeX and Excel
Replies: 2   Last Post: Nov 20, 2013 12:05 PM

Advanced Search

Back to Topic List Back to Topic List Jump to Tree View Jump to Tree View   Messages: [ Previous | Next ]
yann

Posts: 1
Registered: 10/14/13
changing Hyperlink text with activeX and Excel
Posted: Oct 14, 2013 8:09 PM
  Click to see the message monospaced in plain text Plain Text   Click to reply to this topic Reply

I am using activeX to generate an excel file, in this excel file i am adding a hyperlink, i am trying to figure out if there is a way to make it display a different text than the link, for example if the hyperlink links to 'www.google.com' i want it to display 'google'. i know that you can do it with activeX but i cant seem to get it to work with matlab.
I am generating the hyperlink this way:
excel.ActiveSheet.HyperLinks.Add(excel.Activesheet.get('Range','G3'),... 'www.google.com');
there is a function called 'Texttodisplay' in activeX so i thought that i could do something like this:
excel.ActiveSheet.HyperLinks.Add(excel.Activesheet.get('Range','G3'),... 'www.google.com','Texttodisplay','google');
but no luck, thanks for your help.



Point your RSS reader here for a feed of the latest messages in this topic.

[Privacy Policy] [Terms of Use]

© Drexel University 1994-2014. All Rights Reserved.
The Math Forum is a research and educational enterprise of the Drexel University School of Education.