Open a hyperlink in a new page
 

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

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