Hi Guys, I have been banging my head trying to figure out how to do this.... No luck.
I am looking for a simple macro that will go to this webpage http://contests.covers.com/sportscontests/leaders.aspx?sportID=6&ID=15070&sRec=1&eRec=50&hiddenSportID=0 Will pick records 1 through 50 and copy it to a spreadsheet. Then it go back to the same page "press" the next button that will bring you to records 51 through 100 and again copy it to the spreadsheet directly below record 50. IT would then continue on in a loop until it reached the end of the file. Sorry, my limited knowledge with VBA cannot figure this out. Would appreciate any help. 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 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts