VBA Excel:
Is there any way to copy the entire contents of a web page and paste it as Unicode text without using the SendKeys commands for Select All, and Copy?
Printable View
VBA Excel:
Is there any way to copy the entire contents of a web page and paste it as Unicode text without using the SendKeys commands for Select All, and Copy?
http://www.vbforums.com/showthread.p...hreadid=255979
Take a look at the link I posted in the above thread. You can use the inet control to grab a webpage's contents then call on the paste or pastespecial methods of the range object to place this into your Excel sheet...