View Full Version : How to change the target of the hyperlinks in excel VBA ??
aujing
06-17-2006, 12:28 PM
How to change the target of the hyperlinks in excel VBA ??
or could it be done... :eek: :eek:
mdmackillop
06-18-2006, 06:17 AM
Hi Aujing,
Welcome to VBAX.
This should change the hyperlink in the active cell as specified, changing the desciption as well. The basic code for this can be seen by making the cell active and recording the changes you wish to make.
Regards
MD
With ActiveCell
.Formula = "Portal"
.Hyperlinks(1).Address = "http://vbaexpress.com/portal.php"
End With
aujing
06-18-2006, 11:03 AM
oops,, thanks for your help,,
but I mean the target of the hyperlinks,, not the href of the links...
mdmackillop
06-18-2006, 11:16 AM
What type of file is the target, and how do you wish to change it?
aujing
06-18-2006, 11:33 AM
<a href="http://abc.com/index.html" target="abc">
I am using excel to prepare a calendar,,
and using VBA to export to a html file..
which contains some hyperlinks in it,, but I need to set the target of the hyperlinks to a specific frame..
I am thinking if excel VBA support this change of target... ...
mdmackillop
06-18-2006, 11:36 AM
Not something I'm familiar with I'm afraid, but I'm sure someone else can assist.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.