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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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 "http://UserID:(E-Mail Removed)/tips.htm"



--

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


"Gordon" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>
> 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
>