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 ]
Chau Thuan HUYNH

Posts: 3
Registered: 10/23/13
Re: changing Hyperlink text with activeX and Excel
Posted: Nov 20, 2013 11:49 AM
  Click to see the message monospaced in plain text Plain Text   Click to reply to this topic Reply

"yann" wrote in message <l3i133$lud$1@newscl01ah.mathworks.com>...
> 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.

Hello,
I have the same problem! Anybody help us please ?



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.