Thread
:
Macro to copy internet page
View Single Post
#
3
Posted to microsoft.public.excel.programming
Pedro Costa[_3_]
external usenet poster
Posts: 12
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?
Reply With Quote
Pedro Costa[_3_]
View Public Profile
Find all posts by Pedro Costa[_3_]