Copy internet page excel
 

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

Copy internet page excel
 

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

Workbooks.Open Entering UserName & Password
 

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

Workbooks.Open Entering UserName & Password
 

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