Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    England
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    html to excel (office 2003)

    i have a time problem, ( not timing ) i down load a web page from our company site and save it to my desktop. close the web page and then open the web page in excel. what takes me seconds to down load take 3 minutes + to open in excel.
    can any one suggest a method of opening the file so the time lag will not be as noticeable.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: html to excel (office 2003)

    alexanderd

    Could you do this as a web query in Excel

    1)Data|Import External Data

    2) In the new window place the URL of the web source and press import

    This will provide you with fresh data each time you open excel. If you need to save it you could cut and pate to a new work sheet or file
    Jerry

Posting Permissions

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