+ Reply to Thread
Results 1 to 4 of 4

Pull website info into excel

  1. #1
    Registered User
    Join Date
    05-05-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    5

    Pull website info into excel

    Hello everyone, I'm finally giving up and asking for help. I'm a newbie at VBA and I need help pulling data from a website into excel. I put the code that I already have below. I need to pull the text from <ModelID>724316</ModelID> into "Extract Web Data.xlsm". So I would always like to pull the text (in this case, 724316) into cell A1 of "Extract Web Data.xlsm". Would using one of innertext, innerhtml, outertext, or outerhtml to extract the data work or are those functions for something else?

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    05-05-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Pull website info into excel

    Sorry for the bump. I would appreciate any help/insight on the issue.

  3. #3
    Registered User
    Join Date
    05-05-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Pull website info into excel

    Anyone? This is the last bump I promise, then I'll let it sink.

  4. #4
    Valued Forum Contributor
    Join Date
    05-21-2009
    Location
    Great Britain
    MS-Off Ver
    Excel 2003
    Posts
    550

    Re: Pull website info into excel

    What is the URL? Without that, or the HTML from the site it's difficult to help. Also is <ModelID> a HTML tag? I don't recognise it, so maybe you need to parse with XML methods etc.... Google...

    "Would using one of innertext, innerhtml, outertext, or outerhtml to extract the data work". Maybe - have you tried them? Probably innerText is your best bet.
    Post responsibly. Search for excelforum.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1