Results 1 to 5 of 5

Extracting data from imported Webpage VBA

Threaded View

pnaquin Extracting data from imported... 10-25-2011, 10:00 AM
pnaquin Re: Extracting data from... 10-25-2011, 10:22 AM
Kyle123 Re: Extracting data from... 10-25-2011, 10:51 AM
pnaquin Re: Extracting data from... 10-25-2011, 11:07 AM
pnaquin Re: Extracting data from... 10-25-2011, 02:10 PM
  1. #1
    Registered User
    Join Date
    10-25-2011
    Location
    baton rouge, louisiana
    MS-Off Ver
    Excel 2007
    Posts
    12

    Extracting data from imported Webpage VBA

    I'm working on a project and am stumped on how to do a certain task. I've imported some data from a webpage that will refresh at times thus moving the information I need to extract from it around. What I need to do is create a macro that will extract prices that will always follow a certain word. My knowledge of VBA is very limited and I really have no clue as how to do this.

    I've attached the file the page I need to extract data from to better illustrate what I need to do. My macro must extract the prices under the Slaughter Bulls line coming after 1500-2000 lbs. Like I stated the prices will always follow the lbs but could be in different lines when refreshed.

    The sample I sent was in excel 2003 but the project is actually using excel 2007 if that makes a difference.

    Thanks in advance
    Attached Files Attached Files

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