Results 1 to 2 of 2

Thread: Working in Excel 2002 and using Internet Explorer

  1. Jul 31st, 2003, 03:09 PM #1
    Avatarp
    Avatarp is offline

    Thread Starter
    Fanatic Member Avatarp's Avatar
    Join Date
    Sep 2002
    Location
    Calgary
    Posts
    826

    Working in Excel 2002 and using Internet Explorer

    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?
    Reply With Quote Reply With Quote
  2. Aug 1st, 2003, 06:35 AM #2
    alex_read
    alex_read is offline
    Evil Genius alex_read's Avatar
    Join Date
    May 2000
    Location
    Espoo, Finland
    Posts
    5,538
    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...

    Please rate this post if it was useful for you!
    Please try to search before creating a new post,
    Please format code using [ code ][ /code ], and
    Post sample code, error details & problem details
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width