+ Reply to Thread
Results 1 to 2 of 2

Macro to extract data from webpage

  1. #1
    Registered User
    Join Date
    07-18-2011
    Location
    Texas,United States
    MS-Off Ver
    Excel 2003
    Posts
    2

    Macro to extract data from webpage

    Hi,

    I need help with a macro to pull data from this website, http://octane.nmt.edu/gotech/Petrole...njection=False. The macro that I recorded will return nothing in the spreadsheet when I run it. I am fairly new to vba and programming, and I would greatly appreciate help from anyone. The webpage that I am trying to pull data from is updated monthly so I am trying to ultimately modify the macro to capture the changes in the wepage monthly and feed that into the excel spreadsheet. Here is the code that I recorded.

    Please Login or Register  to view this content.


    Again thanks alot for your help

    Brad,
    Last edited by Bradley_99; 07-20-2011 at 11:08 AM. Reason: Added Code tags

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Macro to extract data from webpage

    Hi Bradley_99 and welcome to the forum. Please take a moment to read the forum rules located here and wrap your code with code tags. Once you do that, someone will be able to help you.

    Regards
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

+ 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