Open a hyperlink in a new page

[Guest]

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

 

[William]

Hi Yoav

You could try....

Sub test()
ActiveWorkbook.FollowHyperlink Address:="http://news.bbc.co.uk/", _
NewWindow:=True
End sub
--

-----
XL2003
Regards

William

(e-mail address removed)