+ Reply to Thread
Results 1 to 2 of 2

VBA code to extract info from a series of URLs within a series of web pages

  1. #1
    Registered User
    Join Date
    06-26-2012
    Location
    Michigan, USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Question VBA code to extract info from a series of URLs within a series of web pages

    I am attempting extract a series of profile numbers from this website: http://www.erepublik.com/en/main/gro.../members/12/19. When a member name is clicked on it links to their individual profile, which contains a profile number in the hyperlink. For example, if "Kirras" is click on, the resulting page has URL http://www.erepublik.com/en/citizen/profile/1885594. This string of numbers at the end of the hyperlink is what I need (1885594).

    I was hoping someone could offer advice on a code that would extract the profile ID#, the "1885594," for all members listed on the page in the original hyperlink. Finally, if it is possible, could the macro go through all 129 "regiments" that are selectable through the drop-down box on the original page.

    I appreciate any guidance that someone could offer, because I haven't the foggiest idea where to start...

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: VBA code to extract info from a series of URLs within a series of web pages

    When you say "extract an ID listed in a hyperlink", is this a text string in cell, or a hardcoded hyperlink under the cell (invisible)?

    If you were to provide an actual workbook showing BEFORE and AFTER sheets so we can see the real data and teh real goal, best of all. Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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