View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Pedro Costa[_3_] Pedro Costa[_3_] is offline
external usenet poster
 
Posts: 12
Default Macro to copy internet page

Thanks Tom, but how can i copy the page and paste it to excel in a macro?

"Tom Ogilvy" escreveu:

You can open a URL in excel itself (File=Open= type in the URL).

If you want to use hyperlinks, you could just use their event to trigger a
macro that opens the URL in Excel.

--
Regards,
Tom Ogilvy


"Pedro Costa" <Pedro wrote in message
...
Is there a way to create a macro in order to copy the entire page in an
internet site to excel?

Ill try to explain it better :

I have a list of hyperlinks in a sheet (sheet1), the macro should open

these
hyperlinks and copy all the content of the page and paste it to a certain
sheet (sheet2) in my workbook.

Is this possible?