Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copying Web Page from IE (XL97/2000)

    I want to copy the contents of a specific Web Page into Excel & I can do it manually as follows :

    Go to IE
    Edit/Select All
    Edit/Copy

    Go to Excel
    Edit/Paste

    I now need to do the same thing programmatically using Excel VBA. Does anybody have any good ideas or examples as to how this could best be achieved.

    Thanks for your help

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Copying Web Page from IE (XL97/2000)

    Nick, you want to do a web query (see the Data | Get External Data menu). Q157482 tells how to create a Web Query file, and <A target="_blank" HREF=http://officeupdate.microsoft.com/excel/webquery/samples.htm>here</A> are some samples, again from MS. HTH --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying Web Page from IE (XL97/2000)

    As an alternative to get external data you can also open the webpage straight in XL (File, Open, type the URL)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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