Hi Group,
No success with the problem yet. Anyone else care to take a stab at it ?
Thanks.
On May 26, 2010 10:06pm, 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 URL 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
