Need a macro to jump to IE, copy all and paste on sheet

[rickyckc]

Hi all,

How can this be done ?

1) I'm in sheet, example 'data'
2) When I run a macro, I need it to open/jump to IE to a url, example www.cnn.com
3) Get it to copy all from IE, jump back to a sheet, example 'web' and paste it as text.

Thanks in advance.

Best Regards,

 

[John Davis]

Hi all,

How can this be done ?

1) I'm in sheet, example 'data'
2) When I run a macro, I need it to open/jump to IE to a url, example www.cnn.com
3) Get it to copy all from IE, jump back to a sheet, example 'web' and paste it as text.

Thanks in advance.

Best Regards,

Does this help?

http://www.excelforum.com/excel-programming/465586-macro-to-copy-internet-page.html

http://www.ozgrid.com/forum/showthread.php?t=95694&page=1