PDA

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.