hi Gordon

You can use workbook.open

Sub test()
Workbooks.Open "http://www.rondebruin.nl/tips.htm"
End Sub


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gordon" wrote in message ups.com...
Is there anyway to copy an internet page to excel using VBA?
I am now manually doing a Select All, copy, past method.

Thanks

Gordon