View Single Post
  #2   Report Post  
William
 
Posts: n/a
Default

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