I wanted to know what line of code to use to make a macro
go to a specified web site?

Thanks!!!

Rhonda

the following code will create a hyperlink in the active
cell, then take you to the webpage:-

Sub testHyperlink()

ActiveSheet.Hyperlinks.Add Anchor:=Selection,
Address:= _
"http://communities.microsoft.com/newsgroups/defaul
t.asp?
icp=Prod_Office&sLCID=US&newsgroup=microsoft.publi c.word.ne
wusers" _
, TextToDisplay:="test"
Selection.Hyperlinks(1).Follow NewWindow:=False,
AddHistory:=True

End Sub

hth,

Tony


-----Original Message-----
I wanted to know what line of code to use to make a macro
go to a specified web site?

Thanks!!!
.

Thanks!!


-----Original Message-----
Rhonda

the following code will create a hyperlink in the active
cell, then take you to the webpage:-

Sub testHyperlink()

ActiveSheet.Hyperlinks.Add Anchor:=Selection,
Address:= _
"http://communities.microsoft.com/newsgroups/defa
ul
t.asp?
icp=Prod_Office&sLCID=US&newsgroup=microsoft.publ ic.word.
ne
wusers" _
, TextToDisplay:="test"
Selection.Hyperlinks(1).Follow NewWindow:=False,
AddHistory:=True

End Sub

hth,

Tony


-----Original Message-----
I wanted to know what line of code to use to make a
macro
go to a specified web site?

Thanks!!!
.

.

How would I get the macro to go to the website and then
copy and paste a table back into sheet 2 starting at cell
BN?




-----Original Message-----
Thanks!!


-----Original Message-----
Rhonda

the following code will create a hyperlink in the
active
cell, then take you to the webpage:-

Sub testHyperlink()

ActiveSheet.Hyperlinks.Add Anchor:=Selection,
Address:= _
"http://communities.microsoft.com/newsgroups/def
a
ul
t.asp?
icp=Prod_Office&sLCID=US&newsgroup=microsoft.pub lic.word
..
ne
wusers" _
, TextToDisplay:="test"
Selection.Hyperlinks(1).Follow NewWindow:=False,
AddHistory:=True

End Sub

hth,

Tony


-----Original Message-----
I wanted to know what line of code to use to make a
macro
go to a specified web site?

Thanks!!!
.

.

.

You can use

Workbooks.Open (http://www.yahoo.com/)

This will open a new workbook with the webpage as the worksheet. The table
you are looking for will occupy a range of cells that you can then put where
you like.

HTH,
Shockley



"Rhonda" wrote in message
...
How would I get the macro to go to the website and then
copy and paste a table back into sheet 2 starting at cell
BN?




-----Original Message-----
Thanks!!


-----Original Message-----
Rhonda

the following code will create a hyperlink in the
active
cell, then take you to the webpage:-

Sub testHyperlink()

ActiveSheet.Hyperlinks.Add Anchor:=Selection,
Address:= _
"http://communities.microsoft.com/newsgroups/def
a
ul
t.asp?
icp=Prod_Office&sLCID=US&newsgroup=microsoft.pub lic.word
.
ne
wusers" _
, TextToDisplay:="test"
Selection.Hyperlinks(1).Follow NewWindow:=False,
AddHistory:=True

End Sub

hth,

Tony


-----Original Message-----
I wanted to know what line of code to use to make a
macro
go to a specified web site?

Thanks!!!
.

.

.

Try this examples Rhonda

Sub LoadWebPage1()
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

Sub LoadWebPage2()
ActiveWorkbook.FollowHyperlink Address:="http://www.rondebruin.nl/Google.htm"
End Sub


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



"Rhonda" wrote in message ...
I wanted to know what line of code to use to make a macro
go to a specified web site?

Thanks!!!

Thank you all for your help!






-----Original Message-----
I wanted to know what line of code to use to make a
macro
go to a specified web site?

Thanks!!!
.