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

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

Thank you Ron, It worked. I knew there would be a way.

Next question if there is an answer:

I am calling up a web page that requires a user name & a password, can
VAB handle it?

If so, then have to click on a page called WEB REPORT, from that page
to WHICH REPORT (Sponsorship or Roster) then on that page Date of
report wanted. Any way?

Aloha,
Gordon

You can try this Gordon
But this is not working on all sites

Workbooks.Open "



--

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


"Gordon" wrote in message ups.com...

Thank you Ron, It worked. I knew there would be a way.

Next question if there is an answer:

I am calling up a web page that requires a user name & a password, can
VAB handle it?

If so, then have to click on a page called WEB REPORT, from that page
to WHICH REPORT (Sponsorship or Roster) then on that page Date of
report wanted. Any way?

Aloha,
Gordon