+ Reply to Thread
Results 1 to 5 of 5

Extracting data from imported Webpage VBA

  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

  2. #2
    Registered User
    Join Date
    10-25-2011
    Location
    baton rouge, louisiana
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Extracting data from imported Webpage VBA

    I've attached the Actual Excel 2007 workbook I'm working with.

    I need to extract the data I described above from the cattle summary sheet and put it in the appropriate places in the cattle prices sheet.
    Attached Files Attached Files

  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Extracting data from imported Webpage VBA

    It might be useful if you could post where you are getting the data from, do you have a link?

  4. #4
    Registered User
    Join Date
    10-25-2011
    Location
    baton rouge, louisiana
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Extracting data from imported Webpage VBA

    Here is the goal: Create a
    macro that will go through the data in column A and extract the date of the report, the
    low and high price for 1500-2000 lbs slaughter bulls, calculate the average price, and
    place these values in the appropriate cells in the Cattle Prices sheet


    here is the link the data is coming from, but I've already established a connection when I extracted the data onto the summary worksheet so I should just need to pull the data from the worksheet and not the website

    http://www2.selu.edu/Academics/Facul...s/jk_ls140.txt

  5. #5
    Registered User
    Join Date
    10-25-2011
    Location
    baton rouge, louisiana
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Extracting data from imported Webpage VBA

    any suggestions?

+ 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