Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Link to html page.

9 views
Skip to first unread message

mirena

unread,
Apr 1, 2003, 2:41:49 PM4/1/03
to
I would like to use a macro, which open a html page.
I know the function HyperLink but this function use a cell, in a sheet.
With this macro, I want to see the html page whithout to use a cell.

Thanks for your answers.

Ron de Bruin

unread,
Apr 1, 2003, 3:38:53 PM4/1/03
to
Try this

Sub LoadWebPageTest()
Dim oleIE As Object
Set oleIE = CreateObject("InternetExplorer.Application")
With oleIE
'.TheaterMode = True
.Visible = True
.Navigate "http://www.rondebruin.nl/Google.htm"
End With
End Sub


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl

"mirena" <mir...@wanadoo.fr> wrote in message news:3E89EB7...@wanadoo.fr...

Dick Kusleika

unread,
Apr 1, 2003, 5:21:29 PM4/1/03
to
Mirena

Here's one way

ThisWorkbook.FollowHyperlink "http:\\www.microsoft.com"

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.


"mirena" <mir...@wanadoo.fr> wrote in message
news:3E89EB7...@wanadoo.fr...

mirena

unread,
Apr 2, 2003, 1:54:53 PM4/2/03
to Ron de Bruin
Thank you very much for you answer !
One more question : on my PC, I have only the Netscape Navigator.
What is the keyword to use in the function CreateObject ?

Thanks.

Ron de Bruin

unread,
Apr 2, 2003, 2:34:05 PM4/2/03
to
Hi

I have not Netscape so I don't know about the name in the Create Object for that

You can use this also
ActiveWorkbook.FollowHyperlink Address:="http://www.rondebruin.nl/Google.htm"

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl

"mirena" <mir...@wanadoo.fr> wrote in message news:3E8B31FD...@wanadoo.fr...

0 new messages