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

Link to html page.

15 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