mail me xl @ .......realsa...@gmail.com On Thu, May 27, 2010 at 7:36 AM, Bill Q <ronsmith...@gmail.com> wrote:
> Thanks for the effort Saggi. It is appreciated. > > Unfortunatly, it seems that I am guilty of not being specific > enough.Here is what I need step by step: > > 1. We start on this URL : > http://contests.covers.com/Handicapping/topHandicappers.aspx?sportid=1 > 2. This page defaults to record 1 through 50. > 3. Records 1 through 50 are copied and pasted into a spreadsheet > called TEST001.XLS > 4. The page "somehow" advances to the next (through code). That next > page will be from record 51 to 100. > 5. That is also copy and pasted in TEST001.XLS directly beneath the > last record (in the case 50) > 6. Again, code is created (a loop I guess) so that it once again goes > to the next page that contains records 101 to 151. > 7. Same as step 5. > 8. Etc etc until the end of records has been encountered. In this > particular case there are 18,849 records. > > - You can manually advance to the next page of records by pressing on > the button controls on the ULR page near the bottom where it indicates > "or by placement". > Below is what the output should look like (from two pages only). Of > course this would be in the TEST001 spreadhseet, but I couldn't figure > out how to attach it here. > > Thanks & sorry for the confusion. > > 1 lalito 171-112-7 60.42% 6.15 +24610 View View > 2 scotty122 210-147-10 58.82% 5.56 +24150 View View > 3 eaglezzz 295-225-14 56.73% 4.71 +23750 View View > 4 ForecastinFloyd 165-111-7 59.78% 5.28 +21450 View View > 5 RandyC726 273-210-13 56.52% 4.11 +21000 View View > 6 CC95531 349-280-13 55.48% 3.78 +20500 View View > 7 IWillWinItAll 209-156-7 57.26% 3.85 +18700 View View > 8 redbully 227-173-11 56.75% 3.64 +18350 View View > 9 Cox37 255-199-11 56.17% 3.45 +18050 View View > 10 atmraydoc 212-160-7 56.99% 3.63 +18000 View View > 11 bbk 130-87-5 59.91% 4.26 +17150 View View > 12 DoubleA69 267-212-14 55.74% 3.16 +16900 View View > 13 fatboybbq 192-150-7 56.14% 2.58 +16870 View View > 14 markjsni 158-113-3 58.30% 3.74 +16850 View View > 15 kosta8 165-120-6 57.89% 3.55 +16760 View View > 16 sonofsamtom 264-210-11 55.70% 3.08 +16500 View View > 17 cokeyjoe 343-282-14 54.88% 2.98 +16400 View View > 18 jzduit2 172-127-7 57.53% 3.39 +16150 View View > 19 taquitojames 196-150-7 56.65% 3.06 +15500 View View > 20 Chance2005 243-193-8 55.73% 2.87 +15350 View View > 21 runk5k 199-153-11 56.53% 3.01 +15350 View View > 22 laoplayah 128-89-3 58.99% 3.50 +15050 View View > 23 chris2515 74-40-0 64.91% 5.07 +15000 View View > 24 doggystylze 134-95-4 58.52% 3.32 +14750 View View > 25 norsugai 135-96-3 58.44% 3.29 +14700 View View > 26 peterp 224-177-10 55.86% 2.75 +14650 View View > 27 ptmclc 105-69-1 60.34% 3.72 +14550 View View > 28 ALLABOUTME 273-222-11 55.15% 2.63 +14400 View View > 29 americanbj27 82-49-1 62.60% 4.16 +14050 View View > 30 jwstahl80 348-291-15 54.46% 2.54 +13950 View View > 31 grillbee 109-74-7 59.56% 3.35 +13800 View View > 32 ryanwelser 186-144-5 56.36% 2.67 +13800 View View > 33 JCYeager 159-120-7 56.99% 2.73 +13560 View View > 34 Daweemz04 103-70-4 59.54% 3.15 +13440 View View > 35 howwierd 181-141-7 56.21% 2.48 +13420 View View > 36 chuckgale 159-120-8 56.99% 2.73 +13410 View View > 37 gigglez13 161-122-6 56.89% 2.69 +13400 View View > 38 riba57 285-230-9 55.34% 2.94 +13360 View View > 39 91Bravo 119-84-3 58.62% 3.02 +13300 View View > 40 MADMAN62 142-105-7 57.49% 2.77 +13250 View View > 41 johnnyboy28 252-205-12 55.14% 2.42 +13250 View View > 42 luonz 119-80-5 59.80% 3.82 +13250 View View > 43 djm180 88-56-2 61.11% 3.56 +13200 View View > 44 Smoothie123 233-188-10 55.34% 2.40 +13100 View View > 45 nicawarrior 68-38-3 64.15% 4.25 +13100 View View > 46 datsyuk 81-50-2 61.83% 3.67 +13000 View View > 47 WEZEWOODS69 97-65-4 59.88% 3.16 +12750 View View > 48 rooster010 218-175-10 55.47% 2.35 +12750 View View > 49 master_predict 101-69-2 59.41% 3.01 +12550 View View > 50 haqq55 225-182-12 55.28% 2.27 +12400 View View > 51 star7 73-44-5 62.39% 3.59 +12300 View View > 52 mikeshelton31 130-96-3 57.52% 2.56 +12200 View View > 53 jc2211 241-197-8 55.02% 2.21 +12200 View View > 54 KeyboardCowboy 228-184-9 55.34% 2.35 +12200 View View > 55 Mike208 143-108-5 56.97% 2.44 +12100 View View > 56 DutchMaster24 88-58-4 60.27% 3.08 +12100 View View > 57 SportsLady 155-119-8 56.57% 2.36 +12050 View View > 58 gatorsneil75 93-63-3 59.62% 2.88 +11850 View View > 59 anth611 61-34-3 64.21% 3.84 +11800 View View > 60 Chaas 50-24-1 67.57% 4.57 +11800 View View > 61 tamert 74-46-2 61.67% 3.27 +11700 View View > 62 gruntdabeerman 110-79-3 58.20% 2.54 +11550 View View > 63 SoLjA 89-60-5 59.73% 2.82 +11500 View View > 64 cowgirl2k1 209-167-7 55.59% 2.35 +11490 View View > 65 ADR1977 156-121-6 56.32% 2.21 +11450 View View > 66 vanwilder21 92-63-3 59.35% 2.71 +11350 View View > 67 dech810 83-55-4 60.14% 2.84 +11250 View View > 68 Wicked Jester 63-37-5 63.00% 3.38 +11150 View View > 69 Barry69 184-147-8 55.59% 2.07 +11150 View View > 70 twist38 142-109-2 56.57% 2.17 +11050 View View > 71 itlianstllion11 147-117-5 55.68% 1.70 +11050 View View > 72 chainlighening 255-215-9 54.26% 1.70 +11030 View View > 73 Guzmania 58-33-3 63.74% 3.43 +10850 View View > 74 MexicanBettor 168-133-10 55.81% 2.03 +10850 View View > 75 saggwine1 157-123-6 56.07% 2.06 +10850 View View > 76 ldd0821 113-83-3 57.65% 2.30 +10850 View View > 77 puffNpass702 158-124-3 56.03% 2.05 +10800 View View > 78 kevinloc 60-35-4 63.16% 3.29 +10750 View View > 79 binh66 60-35-1 63.16% 3.29 +10750 View View > 80 zelka 163-128-9 56.01% 2.10 +10700 View View > 81 hltylife 106-77-7 57.92% 2.30 +10650 View View > 82 cbhammer32 75-49-2 60.48% 2.73 +10550 View View > 83 odie1956 317-269-14 54.10% 1.97 +10550 View View > 84 toolman 131-100-5 56.71% 2.08 +10500 View View > 85 RDizzle 104-75-2 58.10% 2.35 +10470 View View > 86 phatassdave 198-161-6 55.15% 1.91 +10450 View View > 87 goose4autigers 88-61-1 59.06% 2.45 +10450 View View > 88 tob17 209-171-12 55.00% 1.90 +10450 View View > 89 robwalton 242-201-8 54.63% 1.90 +10450 View View > 90 Alan Palmer 178-143-8 55.45% 1.91 +10350 View View > 91 insidee 156-123-5 55.91% 1.95 +10350 View View > 92 brazman 101-73-2 58.05% 2.25 +10350 View View > 93 martin684 222-183-13 54.81% 1.88 +10350 View View > 94 JETER22 167-133-7 55.67% 1.93 +10350 View View > 95 citiman 55-32-5 63.22% 3.04 +10340 View View > 96 Hurley3062 302-255-18 54.22% 1.98 +10320 View View > 97 mike999 70-45-1 60.87% 2.72 +10250 View View > 98 kevdogg42 114-85-5 57.29% 2.11 +10250 View View > 99 ROOKIEBETTOR 92-65-2 58.60% 2.32 +10250 View View > 100 youngchung72 203-166-5 55.01% 1.86 +10200 View View > > > > On May 26, 2:17 am, saggi <realsa...@gmail.com> wrote: > > Use those code : > > > > Sub Combine() > > Dim J As Integer > > > > On Error Resume Next > > Sheets(1).Select > > Worksheets.Add ' add a sheet in first place > > Sheets(1).Name = "Combined" > > > > ' copy headings > > Sheets(2).Activate > > Range("A1").EntireRow.Select > > Selection.Copy Destination:=Sheets(1).Range("A1") > > > > ' work through sheets > > For J = 2 To Sheets.Count ' from sheet 2 to last sheet > > Sheets(J).Activate ' make the sheet active > > Range("A1").Select > > Selection.CurrentRegion.Select ' select all cells in this > > sheets > > > > ' select all lines except title > > Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select > > > > ' copy cells selected in the new sheet on last line > > Selection.Copy Destination:=Sheets(1).Range("A65536").End(xlUp) > > (2) > > Next > > End Sub > > > > On May 24, 11:04 pm, qcan <comeonove...@gmail.com> wrote: > > > > > > > > > Hi Group, > > > > > I am not very knowledgable with VBA and would like some help solving a > > > tedious problem. > > > > > - I would like to copy and past each page contained on this URL into 1 > > > spreadsheet (copy/paste 1st 50, then go to line 51 and do the same for > > > the second 50 etc etc.. > > > > http://contests.covers.com/Handicapping/topHandicappers.aspx?sportid=... > > > > > - Each page contains 50 records. > > > - Currently there are approximatly 8500 records. > > > > > Currently the only way I know how to do this is to manually go to each > > > page manually and copy and paste.Obviously, I would prefer something > > > much more automated so that I can keep whatever remaining hair on my > > > head. > > > > > Many thanks. > > > > > -- > > > > ---------------------------------------------------------------------------------- > > > Some important links for excel users: > > > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > HELP US GROW !! > > > > > We reach over 7000 subscribers worldwide and receive many nice notes > about the learning and support from the group.Let friends and co-workers > know they can subscribe to group athttp:// > groups.google.com/group/excel-macros/subscribe- Hide quoted text - > > > > - Show quoted text - > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
