Extracting a list 3

JPJeffery · Sep 2, 2014

Hi

I'm trying to extract multiple instances of part of a URL from the source code of a web page.

All these parts start with the same text but then end with a numeric string (representing the ID number for a round of golf).

Ultimately I'm after just a list of the ID numbers but for now the macro I'm trying to write should
[ol 1]
[li]Select all the text[/li]
[li]Find the first/next instance of "/golfers/score.php?id="[/li]
[li]Ctrl+Shift select to the right (to additionally select the ID number)[/li]
[li]Add that selection to a variable (which I'm delimiting/separating by a ~)[/li]
[li]Repeat from Step 2 until the last instance of the text is found[/li]
[/ol]

(What I'll then do is delete all the text so I have a blank document, then paste in the variable I've built up in the macro then remove all the remaining unwanted text)

Here's the code I have so far:

Code:

Sub GetIDs()
'
' GetIDs Macro
'
'
    Dim strIDs As String
    Selection.WholeStory
    Selection.Find.ClearFormatting
        Do Until Selection.Find.Found = False
            With Selection.Find
                .Text = "/golfers/score.php?id="
                .Forward = True
                .Wrap = wdFindContinue
                .Format = False
                .MatchCase = False
                .MatchWholeWord = False
                .MatchWildcards = False
                .MatchSoundsLike = False
                .MatchAllWordForms = False
            End With
            Selection.Find.Execute
            'Additionally select the next word, which is the unique ID number
            Selection.MoveRight Unit:=wdWord, Count:=1, Extend:=wdExtend
            'Add the selection to the strIDs variable
            strIDs = strIDs & Selection & "~"
        Loop
End Sub

So the strIDs variable will end up looking something like

Code:

/golfers/score.php?id=12345~/golfers/score.php?id=678912~/golfers/score.php?id=3456789~/golfers/score.php?id=1234567

However, all that happens when I step through the code is the 'Do Until Selection.Find.Found = False' line is selected but then the code goes to 'End Sub'.

Clearly I'm missing something pretty obvious. I'm hoping so...

BTW, I'm using Word 2010 but I can't guarantee what version of Word my target audience members will have.

JJ
[small][purple]Variables won't. Constants aren't[/purple]
There is no apostrophe in the plural of PC (or PST, or CPU, or HDD, or FDD, or photo, or breakfast...and so on)[/small]

SkipVought · Sep 2, 2014

Hi,

Hmmmm? Word? Probably my bias, but I'd be using Excel.

Nonetheless, please post a relevant sample of your step 1 so we can see what's being parsed.

JPJeffery · Sep 2, 2014

Well, I'm not wedded to Word! If you think Excel will be easier that's fine by me, but I went with Word because of the format of the text I'm looking at (HTML Source Code). Here's that sample:

HTML:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "[URL unfurl="true"]http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">[/URL]
<html xmlns="[URL unfurl="true"]http://www.w3.org/1999/xhtml"[/URL] xmlns:v="urn:schemas-microsoft-com:vml">
<head>
  <title>Your Scores</title>

  <meta name="robots" content="noindex,nofollow" />	<meta http-equiv="Pragma" content="no-cache">
  <meta http-equiv="Expires" content="-1">
  
  <link rel="alternate" type="application/rss+xml" title="oobgolf (RSS 2.0)" href="[URL unfurl="true"]http://www.oobgolf.com/content/rss.php"[/URL] />
  <link rel="apple-touch-icon-precomposed" href="/images/iphone_oob_icon_114.png"/>
  <meta name="Keywords" content="jpjeffery,handicap,scores" />
<script type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/SystemConfig.js?bn=410"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/Styles.js?bn=410"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/JSLoader.js?bn=410"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/CSSLoader.js?bn=410"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/jsonrpc.js?bn=410"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/jquery-1.6.2.min.js"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/jquery-ui-1.8.14.min.js"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/jquery.cookie.js"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/jquery.ui.wizard.js"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/jquery.ui.skytabs.js"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/jquery.contextmenu.js?bn=410"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/jquery.blockUI.js?bn=410"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/jquery.browser-2.3.js?bn=410"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/jquery.qtip-1.0.0-rc3.min.js?bn=410"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/stringbuilder.js?bn=410"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/sg.resources.php?bn=410"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/sg.core.js?bn=410"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/sg.api.php"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/handlebars.js"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/skyhawke_xdm/easyXDM.js?bn=410"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/gateway/skyxdm_js_methods_public.php?bn=410"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/sg.tmpl.js?bn=410"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/tmpl/tmpl_bundle.php?bn=410"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/main.js?bn=410"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/score_feed.js?bn=410"></script><script[/URL] type="text/javascript" src="[URL unfurl="true"]http://www.oobgolf.com/js/course_review.js"></script><link[/URL] rel='STYLESHEET' type='text/css' href='[URL unfurl="true"]http://www.oobgolf.com/css/datechooser.css?bn=410'/>[/URL]
<link rel='STYLESHEET' type='text/css' href='[URL unfurl="true"]http://www.oobgolf.com/css/clubsg/jquery-ui-1.8.16.custom.css?bn=410'/>[/URL]
<link rel='STYLESHEET' type='text/css' href='[URL unfurl="true"]http://www.oobgolf.com/css/clubsg/jquery-ui-wizard.css?bn=410'/>[/URL]
<link rel='STYLESHEET' type='text/css' href='[URL unfurl="true"]http://www.oobgolf.com/css/jquery.contextmenu.css?bn=410'/>[/URL]
<link rel='STYLESHEET' type='text/css' href='[URL unfurl="true"]http://www.oobgolf.com/css/buttons.css?bn=410'/>[/URL]
<link rel='STYLESHEET' type='text/css' href='[URL unfurl="true"]http://www.oobgolf.com/css/jquery.cluetip.css?bn=410'/>[/URL]
<link rel='STYLESHEET' type='text/css' href='[URL unfurl="true"]http://www.oobgolf.com/css/dashboard.css?bn=410'/>[/URL]
<link rel='STYLESHEET' type='text/css' href='[URL unfurl="true"]http://www.oobgolf.com/css/main.css?bn=410'/>[/URL]
  <style>#header { background-image: url([URL unfurl="true"]http://www.oobgolf.com/images/headers/2.gif);[/URL] }</style>
  <script language="javascript">
  <!--
    window.buildNumber = 410;
    window.authenticated = true;
window.userId = 87259;
window.isMember = 0;
window.userSex = 1;
var tzo = -1*(new Date()).getTimezoneOffset()/60;
if (tzo != 1.00) try { getJSONRPCClient().callRemote("users.updateTimezone", tzo); } catch (e) { }
window.oobSecureUrl = "[URL unfurl="true"]https://www.oobgolf.com";[/URL]
window.oobStaticUrl = "[URL unfurl="true"]http://www.oobgolf.com";[/URL]
window.oobBaseUrl = "";
JSLoader.scripts.push(['/js/SystemConfig.js?bn=410', true]);
JSLoader.scripts.push(['/js/Styles.js?bn=410', true]);
JSLoader.scripts.push(['/js/JSLoader.js?bn=410', true]);
JSLoader.scripts.push(['/js/CSSLoader.js?bn=410', true]);
JSLoader.scripts.push(['/js/jsonrpc.js?bn=410', true]);
JSLoader.scripts.push(['/js/jquery-1.6.2.min.js', true]);
JSLoader.scripts.push(['/js/jquery-ui-1.8.14.min.js', true]);
JSLoader.scripts.push(['/js/jquery.cookie.js', true]);
JSLoader.scripts.push(['/js/jquery.ui.wizard.js', true]);
JSLoader.scripts.push(['/js/jquery.ui.skytabs.js', true]);
JSLoader.scripts.push(['/js/jquery.contextmenu.js?bn=410', true]);
JSLoader.scripts.push(['/js/jquery.blockUI.js?bn=410', true]);
JSLoader.scripts.push(['/js/jquery.browser-2.3.js?bn=410', true]);
JSLoader.scripts.push(['/js/jquery.qtip-1.0.0-rc3.min.js?bn=410', true]);
JSLoader.scripts.push(['/js/stringbuilder.js?bn=410', true]);
JSLoader.scripts.push(['/js/sg.resources.php?bn=410', true]);
JSLoader.scripts.push(['/js/sg.core.js?bn=410', true]);
JSLoader.scripts.push(['/js/sg.api.php', true]);
JSLoader.scripts.push(['/js/handlebars.js', true]);
JSLoader.scripts.push(['/js/skyhawke_xdm/easyXDM.js?bn=410', true]);
JSLoader.scripts.push(['/gateway/skyxdm_js_methods_public.php?bn=410', true]);
JSLoader.scripts.push(['/js/sg.tmpl.js?bn=410', true]);
JSLoader.scripts.push(['/tmpl/tmpl_bundle.php?bn=410', true]);
JSLoader.scripts.push(['/js/main.js?bn=410', true]);
JSLoader.scripts.push(['/js/score_feed.js?bn=410', true]);
JSLoader.scripts.push(['/js/course_review.js', true]);
    -->
  </script>
<script src="[URL unfurl="true"]http://www.google-analytics.com/ga.js"[/URL] type="text/javascript"></script><script type="text/javascript">try { var pageTracker = _gat._getTracker("UA-486365-1"); pageTracker._trackPageview(); } catch(err) {}</script>      <script type='text/javascript' src='[URL unfurl="true"]http://partner.googleadservices.com/gampad/google_service.js'></script>[/URL]
      <script type='text/javascript'>
         //GS_googleAddAdSenseService("ca-pub-1748165034074252");
         //GS_googleEnableAllServices();
      </script>
      <script type='text/javascript'>
      GA_googleAddAttr("Gender", "M");
GA_googleAddAttr("Member", "Basic");
GA_googleAddAttr("Handicap", "21-to-27_9");
      </script>
      <script type='text/javascript'>
      /*
         GA_googleAddSlot("ca-pub-1748165034074252", "oobgolf-Content-Navigation");
         GA_googleAddSlot("ca-pub-1748165034074252", "oobgolf-Course-Navigation");
         GA_googleAddSlot("ca-pub-1748165034074252", "oobgolf-Course-Rectangle");
         GA_googleAddSlot("ca-pub-1748165034074252", "oobgolf-Equipment-Navigation");
         GA_googleAddSlot("ca-pub-1748165034074252", "oobgolf-Equipment-Rectangle");
         GA_googleAddSlot("ca-pub-1748165034074252", "oobgolf-Footer");
         GA_googleAddSlot("ca-pub-1748165034074252", "oobgolf-Golfer-Navigation");
         GA_googleAddSlot("ca-pub-1748165034074252", "oobgolf-Golfer-Rectangle");
         GA_googleAddSlot("ca-pub-1748165034074252", "oobgolf-Header");
      */
      </script>
      <script type='text/javascript'>
         GA_googleFetchAds();
      </script>
  

<script type='text/javascript'>
   var googletag = googletag || {};
   googletag.cmd = googletag.cmd || [];
   (function() {
      var gads = document.createElement('script');
      gads.async = true;
      gads.type = 'text/javascript';
      var useSSL = 'https:' == document.location.protocol;
      gads.src = (useSSL ? 'https:' : 'http:') + '//[URL unfurl="true"]www.googletagservices.com/tag/js/gpt.js';[/URL]
      var node = document.getElementsByTagName('script')[0];
      node.parentNode.insertBefore(gads, node);
   })();
</script>

<script type='text/javascript'>
   googletag.cmd.push(function() {
      googletag.defineSlot('/4185238/oobgolf-Header', [728, 90], 'div-gpt-ad-1356106777833-0').addService(googletag.pubads());
      googletag.pubads().enableSingleRequest();
      googletag.enableServices();
   });
</script>

<script type='text/javascript'>
   googletag.cmd.push(function() {
      googletag.defineSlot('/4185238/oobgolf-Footer', [728, 90], 'div-gpt-ad-1356106426141-0').addService(googletag.pubads());
      googletag.pubads().enableSingleRequest();
      googletag.enableServices();
   });
</script>

<script type='text/javascript'>
   googletag.cmd.push(function() {
      googletag.defineSlot('/4185238/oobgolf-Content-Navigation', [160, 600], 'div-gpt-ad-1356106062861-0').addService(googletag.pubads());
      googletag.pubads().enableSingleRequest();
      googletag.enableServices();
   });
</script>

<script type='text/javascript'>
   googletag.cmd.push(function() {
      googletag.defineSlot('/4185238/oobgolf-GamePage-Rectangle', [300, 250], 'div-gpt-ad-1356105165153-0').addService(googletag.pubads());
      googletag.pubads().enableSingleRequest();
      googletag.enableServices();
   });
</script>

<script type='text/javascript'>
   googletag.cmd.push(function() {
      googletag.defineSlot('/4185238/oobgolf-Home-Rectangle', [300, 250], 'div-gpt-ad-1356105612761-0').addService(googletag.pubads());
      googletag.pubads().enableSingleRequest();
      googletag.enableServices();
   });
</script>

</head>
<body onload="onLoad();">
  <div id="coolWinBackground">&nbsp;</div>
  <div id="coolWinBox">
    <div id="coolWinTitle">&nbsp;</div>
    <div id="coolWinMenu">&nbsp;</div>
    <div id="coolWinContent">&nbsp;</div>
    <div id="coolWinControl">&nbsp;</div>
  </div>
  <div id="coolWinBoxClose"><img src="[URL unfurl="true"]http://www.oobgolf.com/images/spacer.gif"/></div>[/URL]
  <div id="coolWinLoading"><br/><br/><br/><img src="[URL unfurl="true"]http://www.oobgolf.com/images/icons/24x24/w_recycle.png"/></div>[/URL]

	<div id="core"><div id="header">
         <a href="/"><img src="[URL unfurl="true"]http://www.oobgolf.com/images/spacer.gif"[/URL] border="0" width="222" height="90" class="left" /></a>
      
         <!-- oobgolf-Header -->
         <div id='div-gpt-ad-1356106777833-0'>
            <script type='text/javascript'>
               googletag.cmd.push(function() { googletag.display('div-gpt-ad-1356106777833-0'); });
            </script>
         </div>

      </div><!--
  --><div id="menubar">
  <div id="menu_0" class="menuborder"><div class="menu" id="menu_b_0" onclick="window.location.href='/'"  onmouseover="displaySubMenu(0, event);" onmouseout="hideSubMenu(0, event);"><a href="/">home</a></div></div><div id='submenu_0' class='submenu' style='display:none;' onmouseout='hideSubMenu(0, event);' onmouseover='clearHideSubMenu(0, event);'><div class='submenuitem'><a href="/content/help/1-3965.html" class='submenulink'>Features &amp; Pricing</a></div><div class='submenuitem'><a href="/content/help/1-3968.html" class='submenulink'>iPhone App</a></div><div class='submenuitem'><a href="/content/help" class='submenulink'>Help</a></div><div class='submenuitem'><a href="/golfers/invite.php" class='submenulink'>Tell A Friend</a></div><div class='submenuitem'><a href="/content/site+updates" class='submenulink'>Site Updates</a></div></div>
<script>currentMenu = 1;</script><div id="menu_1" class="menuborder"><div class="menu currentmenu" id="menu_b_1" onclick="window.location.href='/golfers/'"  onmouseover="displaySubMenu(1, event);" onmouseout="hideSubMenu(1, event);"><a href="/golfers/">golfers</a></div></div><div id='submenu_1' class='submenu' style='display:none;' onmouseout='hideSubMenu(1, event);' onmouseover='clearHideSubMenu(1, event);'><div class='submenuitem'><a href="/golfers/mygame.php" class='submenulink'>Your Game</a></div><div class='submenuitem'><a href="javascript:openCoolWin('/golfers/edit_score.php?r=7920', 800, 445, true);" class='submenulink'>Enter Score</a></div><div class='submenuitem'><a href="/golfers/search.php" class='submenulink'>Find Golfers</a></div><div class='submenuitem'><a href="/groups/" class='submenulink'>Groups</a></div><div class='submenuitem'><a href="/golfers/leaderboard.php" class='submenulink'>Leaderboard</a></div><div class='submenuitem'><a href="/golfers/best_scores.php" class='submenulink'>Best Scores</a></div><div class='submenuitem'><a href="/content/golfer+of+the+week" class='submenulink'>Golfer of the Week</a></div><div class='submenuitem'><a href="/tournaments/" class='submenulink'>Tournaments</a></div></div>
<div id="menu_2" class="menuborder"><div class="menu" id="menu_b_2" onclick="window.location.href='/courses/'"  onmouseover="displaySubMenu(2, event);" onmouseout="hideSubMenu(2, event);"><a href="/courses/">courses</a></div></div><div id='submenu_2' class='submenu' style='display:none;' onmouseout='hideSubMenu(2, event);' onmouseover='clearHideSubMenu(2, event);'><div class='submenuitem'><a href="/courses/finder/" class='submenulink'>Course Finder</a></div><div class='submenuitem'><a href="/content/reviews/course+reviews" class='submenulink'>Course Reviews</a></div><div class='submenuitem'><a href="/courses/course_db.php" class='submenulink'>Update Courses</a></div><div class='submenuitem'><a href="/tournaments/" class='submenulink'>Tournaments</a></div></div>
<div id="menu_3" class="menuborder"><div class="menu" id="menu_b_3" onclick="window.location.href='/equipment/'"  onmouseover="displaySubMenu(3, event);" onmouseout="hideSubMenu(3, event);"><a href="/equipment/">equipment</a></div></div><div id='submenu_3' class='submenu' style='display:none;' onmouseout='hideSubMenu(3, event);' onmouseover='clearHideSubMenu(3, event);'><div class='submenuitem'><a href="/content/reviews/product+reviews" class='submenulink'>Reviews</a></div><div class='submenuitem'><a href="/equipment/drivers/" class='submenulink'>Drivers</a></div><div class='submenuitem'><a href="/equipment/fairway+woods/" class='submenulink'>Fairway Woods</a></div><div class='submenuitem'><a href="/equipment/hybrids/" class='submenulink'>Hybrids</a></div><div class='submenuitem'><a href="/equipment/irons/" class='submenulink'>Irons</a></div><div class='submenuitem'><a href="/equipment/wedges/" class='submenulink'>Wedges</a></div><div class='submenuitem'><a href="/equipment/putters/" class='submenulink'>Putters</a></div><div class='submenuitem'><a href="/equipment/golf+balls/" class='submenulink'>Balls</a></div><div class='submenuitem'><a href="/equipment/golf+bags/" class='submenulink'>Bags</a></div><div class='submenuitem'><a href="/equipment/training+aids/" class='submenulink'>Training Aids</a></div><div class='submenuitem'><a href="/equipment/shoes/" class='submenulink'>Shoes</a></div><div class='submenuitem'><a href="/equipment/gloves/" class='submenulink'>Gloves</a></div><div class='submenuitem'><a href="/equipment/apparel/" class='submenulink'>Apparel</a></div></div>
<div id="menu_4" class="menuborder"><div class="menu" id="menu_b_4" onclick="window.location.href='/clubhouse/'"  onmouseover="displaySubMenu(4, event);" onmouseout="hideSubMenu(4, event);"><a href="/clubhouse/">clubhouse</a></div></div><div id='submenu_4' class='submenu' style='display:none;' onmouseout='hideSubMenu(4, event);' onmouseover='clearHideSubMenu(4, event);'><div class='submenuitem'><a href="/content/fore+play" class='submenulink'>Fore Play</a></div><div class='submenuitem'><a href="/content/the+wedge+guy" class='submenulink'>The Wedge Guy</a></div><div class='submenuitem'><a href="/content/columns" class='submenulink'>Columns</a></div><div class='submenuitem'><a href="/forums/" class='submenulink'>Forums</a></div><div class='submenuitem'><a href="/content/columns/cigar+lounge" class='submenulink'>Cigar Lounge</a></div><div class='submenuitem'><a href="/tournaments/" class='submenulink'>Tournaments</a></div></div>
<div class="menuright"><a href="/golfers/logout.php">logout</a></div><div class="menuright">|</div>
    <div id="searchHeader">
      <form name="searchKeywordForm" action="/search.php" method="GET" style="display:inline;" onsubmit="return onSearchKeyword();">
      <input type="text" name="q" class='searchHeaderInput'/>
      <select name="t" class="searchHeaderSelect">
      <option value="0">Entire Site</option><option value="1" selected="true">Golfers</option><option value="2">Courses</option><option value="3">Equipment</option><option value="4">Groups</option>      </select>

      <input type="image" width="58" height="18" src="[URL unfurl="true"]http://www.oobgolf.com/images/search.gif"[/URL] style="position:relative;top:3px;"/>
      <input type="hidden" name="n" value=""/>
      <input type="hidden" name="k" value=""/>
      <input type="hidden" name="x" value="1"/>
      <input type="hidden" name="cx" value="014344308485032154820:3twflabsrtu"/>
      <input type="hidden" name="cof" value="FORID:9"/>
      </form>
    </div>
	  
  </div>
  <div class="promoDiv">Upgrade to <a href="/golfers/stats/addict.php">oobgolf addict</a> to <a href="/golfers/stats/available_stats.php">track more stats</a>, <a href="/content/help/1-3968.html">access rangefinder data</a>, edit course data, and more. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="/golfers/stats/addict.php">Upgrade Now &gt;&gt;</a></div><div id="gameheader">jpjeffery<a href="javascript:openCoolWin('/golfers/edit_score.php?r=7606', 800, 445, true);">enter score</a><a href="/golfers/jpjeffery">your game</a><a href="/golfers/scores.php?id=87259">your scores</a><a href="/golfers/groups.php?id=87259">your groups</a><a href="/golfers/equipment.php?id=87259">your equipment</a><a href="/golfers/friends.php?id=87259">your friends</a><a href="/golfers/stats/settings.php?id=87259">your settings</a></div>
  <div id="content">
    
  <font class='pageTitle'>Your Scores</font><br/>

  <table cellpadding="0" cellspacing="0" width="100%" style="margin-bottom:10px;margin-top:10px;">
    <tr>
      <td valign="top" width="128">
        <div class="smallText">
<div style="border:1px solid #999999;float:left;text-align:center;margin-bottom:6px;padding:3px;width:75px;height:100px;cursor:pointer;" onclick="openCoolWin('/golfers/edit_avatar.html', 380, 190, true);"><div style="margin-top:4.5px;margin-left:0px;width:75px;height:91px;background-repeat:no-repeat;background-position: center;background-image:url([URL unfurl="true"]http://downloads.skygolf.com/image/fileid=13847&filename=1395307825&maxheight=91&maxwidth=75&quality=90&paddingcolor=ffffff);">&nbsp;</div></div><div[/URL] style="clear:left;">&nbsp;</div><a href='/golfers/jpjeffery'>Game</a><br/><a href='/golfers/scores.php?id=87259'>Scores</a><br/><a href='/golfers/reports.php?id=87259'>Reports/Charts</a><br/><a href='/golfers/equipment.php?id=87259'>Equipment</a><br/><a href='/golfers/friends.php?id=87259'>Friends</a><br/><a href='/golfers/groups.php?id=87259'>Groups</a><br/><a href='/golfers/images.php?id=87259'>Images</a><br/><br/>Actions<br/>&nbsp;&nbsp;<a href='javascript:openCoolWin("/golfers/edit_score.php?r=6105", 800, 445, true);'>Enter Score</a><br/>&nbsp;&nbsp;<a href="/golfers/stats/settings.php">Edit Settings</a><br/>&nbsp;&nbsp;<a href="/forums/privmsg.php?folder=inbox">Check Inbox</a><br/>&nbsp;&nbsp;<a href='/golfers/share.php?id=87259'>Share</a><br/><br/><script type="text/javascript">GA_googleFillSlot("oobgolf-Golfer-Navigation");</script><br/><br/></div>














      </td>
      <td style="border-right: 1px dashed #666666;" width="1">&nbsp;</td>
      <td style="padding-left:15px;" class="smallText" valign="top">

  <div style='float:right;margin:0px 0px 20px 10px'>&nbsp;&nbsp;<a class='smallText' href='/golfers/scores.php?id=87259&s=d&d=0&o=50'>next</a><a class='smallText' href='/golfers/scores.php?id=87259&s=d&d=0&o=50'><img src='/images/icons/16x16/w_arrow_right_blue.png' width='16' height='16' border='0' style='position:relative;top:4px;margin-left:4px;'/></a></div>  

  <font class="smallText">1 through 50 of 115 scores</font>
  
  <table cellpadding="2" cellspacing="0" width="100%" style="margin-bottom:10px;">
    <tr>  <td class='smallText bold'><a href='/golfers/scores.php?id=87259&s=d&d=1'>Date <img src='/images/icons/16x16/w_arrow_down_green2.png' width='16' height='9' border='0'/></a></td>  <td class='smallText bold'><a href='/golfers/scores.php?id=87259&s=c'>Course</a></td>  <td class='smallText bold'><a href='/golfers/scores.php?id=87259&s=p'>Avg. Putts</a></td>  <td class='smallText bold'><a href='/golfers/scores.php?id=87259&s=f'>Fairway %</a></td>  <td class='smallText bold'><a href='/golfers/scores.php?id=87259&s=g'>GIR %</a></td>  <td class='smallText bold'><a href='/golfers/scores.php?id=87259&s=s'>Score</a></td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=3079576';">  <td class='smallText'>27/8/14</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>1.81</td>  <td class='smallText'>50</td>  <td class='smallText'>12.5</td>  <td class='smallText'>96</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=3074477';">  <td class='smallText'>23/8/14</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>2.06</td>  <td class='smallText'>21.4</td>  <td class='smallText'>5.6</td>  <td class='smallText'>110&nbsp;T</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=3062148';">  <td class='smallText'>15/8/14</td>  <td class='smallText'>Sundridge Park Golf Club: West</td>  <td class='smallText'>1.89</td>  <td class='smallText'>69.2</td>  <td class='smallText'>11.1</td>  <td class='smallText'>98</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=3053534';">  <td class='smallText'>9/8/14</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>2.11</td>  <td class='smallText'>50</td>  <td class='smallText'>0</td>  <td class='smallText'>123&nbsp;T</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=3019514';">  <td class='smallText'>20/7/14</td>  <td class='smallText'>Bromley Golf Centre</td>  <td class='smallText'>1.89</td>  <td class='smallText'>42.9</td>  <td class='smallText'>11.1</td>  <td class='smallText'>55&nbsp;P</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=3009867';">  <td class='smallText'>12/7/14</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>1.78</td>  <td class='smallText'>28.6</td>  <td class='smallText'>5.6</td>  <td class='smallText'>113&nbsp;T</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2985109';">  <td class='smallText'>29/6/14</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>2</td>  <td class='smallText'>21.4</td>  <td class='smallText'>5.6</td>  <td class='smallText'>111&nbsp;T</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2978680';">  <td class='smallText'>24/6/14</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>2.38</td>  <td class='smallText'>44.4</td>  <td class='smallText'>7.7</td>  <td class='smallText'>82&nbsp;P</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2958764';">  <td class='smallText'>12/6/14</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>2.11</td>  <td class='smallText'>42.9</td>  <td class='smallText'>11.1</td>  <td class='smallText'>103</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2942059';">  <td class='smallText'>1/6/14</td>  <td class='smallText'>Sundridge Park Golf Club: East</td>  <td class='smallText'>1.72</td>  <td class='smallText'>35.7</td>  <td class='smallText'>5.6</td>  <td class='smallText'>105</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2916746';">  <td class='smallText'>17/5/14</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>2.17</td>  <td class='smallText'>71.4</td>  <td class='smallText'>27.8</td>  <td class='smallText'>100</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2913900';">  <td class='smallText'>15/5/14</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>2.22</td>  <td class='smallText'>28.6</td>  <td class='smallText'>22.2</td>  <td class='smallText'>53</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2891472';">  <td class='smallText'>27/4/14</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>1.89</td>  <td class='smallText'>64.3</td>  <td class='smallText'>11.1</td>  <td class='smallText'>110</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2879773';">  <td class='smallText'>18/4/14</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>2.06</td>  <td class='smallText'>64.3</td>  <td class='smallText'>11.1</td>  <td class='smallText'>102</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2875198';">  <td class='smallText'>13/4/14</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>1.78</td>  <td class='smallText'>57.1</td>  <td class='smallText'>11.1</td>  <td class='smallText'>106</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2867425';">  <td class='smallText'>5/4/14</td>  <td class='smallText'>Westerham Golf Club</td>  <td class='smallText'>1.72</td>  <td class='smallText'>42.9</td>  <td class='smallText'>5.6</td>  <td class='smallText'>115</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2857174';">  <td class='smallText'>22/3/14</td>  <td class='smallText'>Selsdon Park Hotel Golf Club</td>  <td class='smallText'>2</td>  <td class='smallText'>64.3</td>  <td class='smallText'>5.6</td>  <td class='smallText'>106</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2848353';">  <td class='smallText'>9/3/14</td>  <td class='smallText'>Selsdon Park Hotel Golf Club</td>  <td class='smallText'>2.33</td>  <td class='smallText'>42.9</td>  <td class='smallText'>11.1</td>  <td class='smallText'>118</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2843821';">  <td class='smallText'>1/3/14</td>  <td class='smallText'>Chelsfield Lakes Golf Centre: Lakes</td>  <td class='smallText'>1.5</td>  <td class='smallText'>50</td>  <td class='smallText'>11.1</td>  <td class='smallText'>100</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2841177';">  <td class='smallText'>24/2/14</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>2.22</td>  <td class='smallText'>50</td>  <td class='smallText'>5.6</td>  <td class='smallText'>111&nbsp;P</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2839278';">  <td class='smallText'>22/2/14</td>  <td class='smallText'>Bromley Golf Centre</td>  <td class='smallText'>2.11</td>  <td class='smallText'>42.9</td>  <td class='smallText'>22.2</td>  <td class='smallText'>50</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2817841';">  <td class='smallText'>12/1/14</td>  <td class='smallText'>Addington Court Golf Centre: Falconwood</td>  <td class='smallText'>1.83</td>  <td class='smallText'>15.4</td>  <td class='smallText'>0</td>  <td class='smallText'>103&nbsp;P</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2789761';">  <td class='smallText'>17/11/13</td>  <td class='smallText'>Surrey National Golf Club</td>  <td class='smallText'>2.17</td>  <td class='smallText'>6.7</td>  <td class='smallText'>0</td>  <td class='smallText'>122</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2785001';">  <td class='smallText'>10/11/13</td>  <td class='smallText'>Oaks Sports Centre: 18-hole course</td>  <td class='smallText'>1.81</td>  <td class='smallText'>23.1</td>  <td class='smallText'>0</td>  <td class='smallText'>101&nbsp;P</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2773100';">  <td class='smallText'>26/10/13</td>  <td class='smallText'>Addington Court Golf Centre: Championship Course</td>  <td class='smallText'>1.9</td>  <td class='smallText'>30.8</td>  <td class='smallText'>0</td>  <td class='smallText'>100&nbsp;P</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2767846';">  <td class='smallText'>20/10/13</td>  <td class='smallText'>Lullingstone Park Golf Course: Castle 18</td>  <td class='smallText'>1.72</td>  <td class='smallText'>42.9</td>  <td class='smallText'>5.6</td>  <td class='smallText'>107</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2753424';">  <td class='smallText'>6/10/13</td>  <td class='smallText'>Addington Court Golf Centre: Championship Course</td>  <td class='smallText'>1.94</td>  <td class='smallText'>69.2</td>  <td class='smallText'>11.1</td>  <td class='smallText'>95</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2743747';">  <td class='smallText'>28/9/13</td>  <td class='smallText'>Shirley Park Golf Club</td>  <td class='smallText'>2.39</td>  <td class='smallText'>28.6</td>  <td class='smallText'>11.1</td>  <td class='smallText'>111&nbsp;P</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2736341';">  <td class='smallText'>22/9/13</td>  <td class='smallText'>Addington Court Golf Centre: Falconwood</td>  <td class='smallText'>1.89</td>  <td class='smallText'>61.5</td>  <td class='smallText'>5.6</td>  <td class='smallText'>104</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2722488';">  <td class='smallText'>12/9/13</td>  <td class='smallText'>Addington Court Golf Centre: Championship Course</td>  <td class='smallText'>2.06</td>  <td class='smallText'>61.5</td>  <td class='smallText'>11.1</td>  <td class='smallText'>99</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2716592';">  <td class='smallText'>8/9/13</td>  <td class='smallText'>Chelsfield Lakes Golf Centre: Lakes</td>  <td class='smallText'>2</td>  <td class='smallText'>28.6</td>  <td class='smallText'>5.6</td>  <td class='smallText'>112</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2706954';">  <td class='smallText'>2/9/13</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>2.11</td>  <td class='smallText'>42.9</td>  <td class='smallText'>22.2</td>  <td class='smallText'>51</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2702791';">  <td class='smallText'>31/8/13</td>  <td class='smallText'>Oaks Sports Centre: 18-hole course</td>  <td class='smallText'>1.89</td>  <td class='smallText'>15.4</td>  <td class='smallText'>5.6</td>  <td class='smallText'>100</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2687905';">  <td class='smallText'>22/8/13</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>1.67</td>  <td class='smallText'>28.6</td>  <td class='smallText'>0</td>  <td class='smallText'>52</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2677463';">  <td class='smallText'>17/8/13</td>  <td class='smallText'>Botley Park Golf Club</td>  <td class='smallText'>2</td>  <td class='smallText'>53.8</td>  <td class='smallText'>0</td>  <td class='smallText'>127&nbsp;P</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2674538';">  <td class='smallText'>15/8/13</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>2</td>  <td class='smallText'>42.9</td>  <td class='smallText'>22.2</td>  <td class='smallText'>56</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2656982';">  <td class='smallText'>6/8/13</td>  <td class='smallText'>Kirkbymoorside Golf Club</td>  <td class='smallText'>2.22</td>  <td class='smallText'>42.9</td>  <td class='smallText'>5.6</td>  <td class='smallText'>122</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2580399';">  <td class='smallText'>29/6/13</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>1.94</td>  <td class='smallText'>14.3</td>  <td class='smallText'>0</td>  <td class='smallText'>111</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2540311';">  <td class='smallText'>8/6/13</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>2.06</td>  <td class='smallText'>42.9</td>  <td class='smallText'>11.1</td>  <td class='smallText'>112</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2505024';">  <td class='smallText'>19/5/13</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>2.33</td>  <td class='smallText'>50</td>  <td class='smallText'>5.6</td>  <td class='smallText'>102</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2485770';">  <td class='smallText'>7/5/13</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>1.89</td>  <td class='smallText'>42.9</td>  <td class='smallText'>5.6</td>  <td class='smallText'>105</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2485757';">  <td class='smallText'>3/5/13</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>2.06</td>  <td class='smallText'>28.6</td>  <td class='smallText'>5.6</td>  <td class='smallText'>119&nbsp;P</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2468974';">  <td class='smallText'>28/4/13</td>  <td class='smallText'>Addington Court Golf Centre: Falconwood</td>  <td class='smallText'>1.61</td>  <td class='smallText'>38.5</td>  <td class='smallText'>5.6</td>  <td class='smallText'>94</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2458846';">  <td class='smallText'>21/4/13</td>  <td class='smallText'>Bromley Golf Centre</td>  <td class='smallText'>1.67</td>  <td class='smallText'>42.9</td>  <td class='smallText'>0</td>  <td class='smallText'>46</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2450390';">  <td class='smallText'>14/4/13</td>  <td class='smallText'>High Elms Golf Club</td>  <td class='smallText'>2.17</td>  <td class='smallText'>50</td>  <td class='smallText'>5.6</td>  <td class='smallText'>123</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2400700';">  <td class='smallText'>15/2/13</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>1.94</td>  <td class='smallText'>64.3</td>  <td class='smallText'>5.6</td>  <td class='smallText'>105</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2396802';">  <td class='smallText'>8/2/13</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>2</td>  <td class='smallText'>50</td>  <td class='smallText'>11.1</td>  <td class='smallText'>104</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2332387';">  <td class='smallText'>30/10/12</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>2.06</td>  <td class='smallText'>64.3</td>  <td class='smallText'>0</td>  <td class='smallText'>113</td></tr><tr class='scoreRowDark' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowDark';" onclick="window.location.href='/golfers/score.php?id=2320930';">  <td class='smallText'>19/10/12</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>1.83</td>  <td class='smallText'>35.7</td>  <td class='smallText'>5.6</td>  <td class='smallText'>109</td></tr><tr class='scoreRowLight' onmouseover="this.className='scoreRowOver';"  onmouseout="this.className='scoreRowLight';" onclick="window.location.href='/golfers/score.php?id=2311344';">  <td class='smallText'>10/10/12</td>  <td class='smallText'>Beckenham Place Park Golf Club</td>  <td class='smallText'>2.06</td>  <td class='smallText'>57.1</td>  <td class='smallText'>0</td>  <td class='smallText'>113</td></tr>

  </table>
  <div style='float:right;margin:0px 0px 20px 10px'>&nbsp;&nbsp;<a class='smallText' href='/golfers/scores.php?id=87259&s=d&d=0&o=50'>next</a><a class='smallText' href='/golfers/scores.php?id=87259&s=d&d=0&o=50'><img src='/images/icons/16x16/w_arrow_right_blue.png' width='16' height='16' border='0' style='position:relative;top:4px;margin-left:4px;'/></a></div>  
  
  </td>
  </tr>
</table>
  </div>
          <div class="portletSpacer" style="clear:both;"></div>
          <center>
<script type='text/javascript'><!--// <![CDATA[
//GA_googleFillSlot("oobgolf-Footer");
// ]]> --></script>

   <!-- oobgolf-Footer -->
   <div id='div-gpt-ad-1356106426141-0' style='width:728px; height:90px;'>
      <script type='text/javascript'>
      googletag.cmd.push(function() { googletag.display('div-gpt-ad-1356106426141-0'); });
      </script>
   </div>

</center>
                    <div id="footer">
            <div class="right" style="text-align:right;">
            	oobgolf.com is the technology platform that connects 
            	<br/><a href="/golfers/">golfers</a>, <a href="/groups/">leagues</a>, <a href="/golfers/leaderboard.php">scores</a>, <a href="/courses/finder/">courses</a>, and <a href="/equipment/">equipment</a>.
            	
            	<br/><br/>
							Use of this site constitutes acceptance of our<br/>
							<a href='/golfers/terms.php' class="footer" rel="nofollow">Terms of Use</a>
							and <a href='/golfers/privacy.php' class="footer" rel="nofollow">Privacy Statement</a>.<br/>
            	&copy; oobgolf All rights reserved.
            </div>

          <div class="left" style="width:130px;">jpjeffery<div style="margin-left:8px;"><a href="javascript:openCoolWin('/golfers/edit_score.php?r=431', 800, 445, true);" rel='nofollow'>Enter Score</a><br/><a href="/golfers/jpjeffery" rel="nofollow">Your Game</a><br/><a href="/golfers/scores.php?id=87259" rel="nofollow">Your Scores</a><br/><a href="/golfers/groups.php?id=87259" rel="nofollow">Your Groups</a><br/><a href="/golfers/equipment.php?id=87259" rel="nofollow">Your Equipment</a><br/></div></div>	            <div class="left" style="width:130px;">
	              Popular
	              <div style="margin-left:8px;">
	            		<a href="/courses/finder/">Course Finder</a><br/>
	            		<a href="/equipment/">Equipment</a><br/>
	            		<a href="/groups/">Groups</a><br/>
	            		<a href="/forums/">Forums</a><br/>
	            		<a href="/content/fore+play">Fore Play</a><br/>
	            	</div>
	           </div>
	            
	            <div class="left" style="width:155px;">
	              Sponsors
	              <div style="margin-left:8px;">
	              	<a href="[URL unfurl="true"]http://www.scorgolf.com">SCOR[/URL] Golf</a><br/>
	              	<a href="[URL unfurl="true"]http://www.golfnow.com/">Golf[/URL] Now</a><br/>
	              	<a href="[URL unfurl="true"]http://www.mizunousa.com/golf">Mizuno</a><br/>[/URL]
	              	<a href="[URL unfurl="true"]http://www.nike.com/nikeos/p/nikegolf/en_US/">Nike</a>[/URL]
	            	</div>
	            </div>
	            <div class="left" style="width:130px;">
	              Company
	              <div style="margin-left:8px;">
	            		<a href="/courses/partner/" rel="nofollow">Course Partners</a><br/>
									<a href="/aboutus.php">About Us</a><br/>
	            		<a href="mailto:info@oobgolf.com" rel="nofollow">Contact Us</a>
	            	</div>
	            </div>
	            
          </div>
          
										</div>
      
        <div id="chooserSpan" class="dateChooser select-free" style="width:160px;display:none;"></div>

        <!--google analytics-->
        						<script type="text/javascript">
						_qoptions={ qacct:"p-f5ztoNv6Clx8Y"};
						</script>
						<script type="text/javascript" src="[URL unfurl="true"]http://edge.quantserve.com/quant.js"></script>[/URL]
						<noscript>
						<img src="[URL unfurl="true"]http://pixel.quantserve.com/pixel/p-f5ztoNv6Clx8Y.gif"[/URL] style="display: none;" border="0" height="1" width="1" alt="Quantcast"/>
						</noscript>
		        
      </body>
    </html>

JJ
[small][purple]Variables won't. Constants aren't[/purple]
There is no apostrophe in the plural of PC (or PST, or CPU, or HDD, or FDD, or photo, or breakfast...and so on)[/small]

SkipVought · Sep 2, 2014

I was assuming that you were actually doing a web query ( a feature in Excel)

Maybe you ought to explain what it is you're trying to accomplish overall.

JPJeffery · Sep 2, 2014

Ultimately I'm trying to extract the scores stored at the web site, in to Excel, using Web Queries (I have the VBA code for this already, by the way). To do this I need the unique part of the web page address of each score, but these are hidden within the source code of the main web page.

The sample HTML code I've just provided above is of that main web page which lists the links to all the scores (well, 50 at a time). I briefly looked in to running a Web Query but that was never going to work because it doesn't grab the source code.

So, as I said, the code above is from the main page (the Index, if you like) that lists the links to each of the scores pages (one for each round). These individual score pages are in the format
[ul]
[li]

http://www.oobgolf.com/golfers/score.php?id=123456

[/li]
[li]

http://www.oobgolf.com/golfers/score.php?id=7890123

[/li]
[li]

http://www.oobgolf.com/golfers/score.php?id=4567890

[/li]
[/ul]
But of course these URLs are hidden away amongst all that other HTML code.

So, I've had to make some manual effort to copy and paste (in to Word) the source code of the Index page at which point the VBA code I'm asking about in this thread is meant to extract these URLs, in to a variable, so that I end up with a list much like the example bullet list in this reply.

Hopefully that's clear. It may not be, I tend to ramble a bit and it's 23:44 here in the UK so I'm just off to bed! In case it helps, here's the URL of the (first) 'index' page (on which you'll get to see a picture of me. Aren't you lucky?!):

http://www.oobgolf.com/golfers/scores.php?id=87259

JJ
[small][purple]Variables won't. Constants aren't[/purple]
There is no apostrophe in the plural of PC (or PST, or CPU, or HDD, or FDD, or photo, or breakfast...and so on)[/small]

MakeItSo · Sep 3, 2014

Hm.
I'd use HTML DOM (=Microsoft HTML Object library), parse the code for all Anchors (a Tags) and read their href attribute value.

Have a look at these two approaches, they might help:

http://www.wiseowl.co.uk/blog/s393/scrape-website-html.htm

http://www.mrexcel.com/forum/excel-...cells-via-visual-basic-applications-code.html

Cheers,
MakeItSo

“Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family.” (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.

PHV · Sep 3, 2014

What about this small changes in your code ?

Code:

Sub GetIDs()
'
' GetIDs Macro
'
'
Dim strIDs As String
Selection.WholeStory
Selection.Find.ClearFormatting
[!]Do[/!]
    With Selection.Find
        .Text = "/golfers/score.php?id="
        .Forward = True
        .Wrap = [!]wdFindStop[/!]
        .Format = False
        .MatchCase = False
        .MatchWholeWord = False
        .MatchWildcards = False
        .MatchSoundsLike = False
        .MatchAllWordForms = False
    End With
    Selection.Find.Execute
    [!]If Selection.Find.Found = False Then
        Exit Do
    End If[/!]
    'Additionally select the next word, which is the unique ID number
    Selection.MoveRight Unit:=wdWord, Count:=1, Extend:=wdExtend
    'Add the selection to the strIDs variable
    strIDs = strIDs & Selection & "~"
    [!]Selection.MoveRight Unit:=wdWord, Count:=1[/!]
Loop
End Sub

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

JPJeffery · Sep 3, 2014

Thanks.

The WiseOwl approach looks easier (or at least, more clearly explained) but the first thing that article says to do is enable the 'Microsoft HTML Object Library' and 'Microsoft Internet Controls' in VBA. We need to take in to account that my target audience are not IT people. So, is this something that will follow the spreadsheet I send them?

JJ
[small][purple]Variables won't. Constants aren't[/purple]
There is no apostrophe in the plural of PC (or PST, or CPU, or HDD, or FDD, or photo, or breakfast...and so on)[/small]

JPJeffery · Sep 3, 2014

PHV, your edits have worked a treat. Thank you.

JJ
[small][purple]Variables won't. Constants aren't[/purple]
There is no apostrophe in the plural of PC (or PST, or CPU, or HDD, or FDD, or photo, or breakfast...and so on)[/small]

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Extracting a list 3

JPJeffery

Technical User

SkipVought

Programmer

JPJeffery

Technical User

SkipVought

Programmer

JPJeffery

Technical User

MakeItSo

Programmer

PHV

MIS

JPJeffery

Technical User

JPJeffery

Technical User

Similar threads

Part and Inventory Search

Sponsor