Thread
:
Open a hyperlink in a new page
View Single Post
#
2
William
Posts: n/a
Hi Yoav
You could try....
Sub test()
ActiveWorkbook.FollowHyperlink Address:="http://news.bbc.co.uk/", _
NewWindow:=True
End sub
--
-----
XL2003
Regards
William
"Yoav" wrote in message
...
Hi,
I am saving my excel worksheet which contains a hyperlink to a web site,
as
HTML.
When I try to navigate to that link, it opens in the same page.
I want it to open in a new page, and since there was no option for that
when
I created the hyperlink, I don't know how to solve it. (BTW, WORD has a
"target frame" option).
Any suggestions? Can it be done programmatically?
Fixing the HTML file manually every save, is not an option.
Thanks
Reply With Quote