+ Reply to Thread
Results 1 to 3 of 3

Web Scraping Help

  1. #1
    Registered User
    Join Date
    03-01-2016
    Location
    Salt Lake City, UT
    MS-Off Ver
    MS 2013
    Posts
    2

    Web Scraping Help

    Hello,

    I'm pretty new to all this and can use a little help. I'm trying to scrape a website and for the order status on about 400 different orders and return it to an empty cell in my excel workbook. I've figured out how to access each order on the site but can't figure out how to return the order status to the workbook. I've come close to figuring it out but it will just continuously change 1 cell instead of populate the information for each order down the column. Any help on this is greatly appreciated! Thank you!

  2. #2
    Forum Contributor
    Join Date
    06-02-2015
    Location
    delhi
    MS-Off Ver
    2010
    Posts
    104

    Re: Web Scraping Help

    You need to find out the tags that are holding the piece of info you are looking for and get the inner text for that element !!

  3. #3
    Registered User
    Join Date
    03-01-2016
    Location
    Salt Lake City, UT
    MS-Off Ver
    MS 2013
    Posts
    2

    Re: Web Scraping Help

    I've done that the only problem i'm having is returning the inner text to excel workbook. When i do this it only changes 1 cell over and over again instead of entering the info in and going down to the next row.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. help web scraping vba
    By kirby21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-24-2015, 09:34 PM
  2. Web scraping
    By vijay.jp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2015, 08:07 AM
  3. Web scraping
    By vijay.jp in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-02-2015, 12:56 AM
  4. Web Scraping
    By Thomo88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-29-2014, 07:21 AM
  5. New to VBA - Web Scraping
    By cringle in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 12-17-2013, 08:26 AM
  6. Web Scraping
    By redkilner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-03-2013, 09:00 AM
  7. [SOLVED] Web scraping with xml
    By abousetta in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-24-2012, 05:25 AM

Tags for this Thread

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