Results 1 to 4 of 4
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Getting source of a page into Excel (Access XP)

    Does anybody know how to firstly address an Internet Browser page then import the text details from the page into either Excel or a CSV file?
    I need to ultimately get this data into an Access table.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Getting source of a page into Excel (Access XP)

    Pat,

    I can't help you with this one, but I don't know if this is the best forum for your question, since Access is not the primary subject. If you don't get answers here, consider posting in one of the other forums, although it's hard to say which is best - Internet Explorer, or Excel perhaps?

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Getting source of a page into Excel (Access XP)

    Hi Hans
    You are not expected to know everything.

    But I need to get this into Access, so I was wondering what kind of API's I might need to execute from Access to address this.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Getting source of a page into Excel (Access XP)

    I presume you are wanting to do this programatically, but I don't think API calls are really going to help here. The challenge appears to be automating a web browser - and most browsers don't expose any sort of object model for fairly obvious reasons. You can however save a web page as a TXT file if you are using IE, but your challenge would then be to convince IE to do it under program control. I think you may be stuck with a manual process.
    Wendell

Posting Permissions

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