| 0 |
Subject: Top 100 Review Spreadsheet Available Here
Posted by: RecycledSpinalFluid
- [21446223] Wed, Sep 05, 03:44
OK, here is the top_100_trackers.zip available for downloading and running at your leisure. I know it works in Excel 97, and I suspect it works in Excel 2000 (but personal don't care).
To use it is fairly simple.
1.) Click "Process Top 100 Team Data"
1a.) Wait...
2.) Create a new thread in the Baseball Standings Forum.
3.) Click "Create Traditional Static Thread"
3a.) Post the copied info as POST 1 in the thread.
4.) Click "Create Head2Head Thread"
4a.) Post the copied info as POST 2 in the thread.
5.) Click "Create Ownership Thread"
5a.) Wait...
5b.) Wait some more...
5c.) Post the copied info as POST 3 in the thread.
In steps 3a, 4a and 5c, be sure to select "YES" to Ignore Line Feeds, when posting, otherwise, things get messy.
To add in new Gurupies to the lookup chart, click the "Add Gurupie Names to Lookup Chart" and follow the simple directions.
I figure I am good for one more posting (9/5), unless someone else does it before me.
One last note. To maintain accuracy of the ownership data, the spreadsheet should be run daily (whether or not you plan/do post the information).
Thanks and Good Luck (and where are those volunteers now? :-). )
|
| 1 | rockafellerskank
Donor
ID: 4911539
Wed, Sep 05, 15:00
|
RSF Trying to run te MS Top 100 spreadsheet..
getting the following error:
Run-time error '9':
Subscript out of range
any help appreciated.
rfs
|
| 2 | RecycledSpinalFluid
ID: 21446223
Thu, Sep 06, 00:08
|
2 Questions:
A.) What version of Excel are you using?
II.) What is the line that comes up when you hit the "DEBUG" option?
|
| 3 | rockafellerskank
Donor
ID: 4911539
Thu, Sep 06, 00:33
|
RSF-
A.) Excel 1997 & II) here is the DEBUG which is hilighted in yellow:
Workbooks(URLtoUse(i)).Close
rfs
|
| 4 | RecycledSpinalFluid
ID: 21446223
Thu, Sep 06, 00:39
|
OK, at that point, hover over i, then URLtoUse, and tell me what the values are.
Does it act like it has read any teams (or at what point does this happen)?
|
| 5 | rockafellerskank
Donor
ID: 4911539
Thu, Sep 06, 07:20
|
i = 1
URLtoUSE http//fantasygames.sortingnews.com/baseball/midseason/fanta...
rfs
|
| 6 | Dan
Donor
ID: 45054169
Sat, Sep 08, 15:03
|
Having a problem with the FS version right now, my guess is that it is some problem with SW as I was encountering a lot of errors while browsing through my teams this morning!
This is the error:
Run-time error '1004'
Microsoft Excel cannot access the file
'http://fantasygames.sportingnews.com/baseball/fullseason/fantasy/games...'
Then when I go to the debug screen this 'Workbooks.Open FileName:=URLtoUse(i)' is highlighted...So im not sure what the problem is but Im going to go with my original assumption that it is Stallworld, please let me know otherwise. Thanks.
|
| 7 | RecycledSpinalFluid
ID: 31822122
Fri, Sep 21, 22:15
|
BUTT for philflyboy
|
| 8 | philflyboy
ID: 1011562618
Fri, Sep 21, 22:23
|
thanks RSF!!!
|
| 9 | RecycledSpinalFluid
ID: 31822122
Fri, Sep 21, 22:25
|
Also just sent you a couple of emails. I'll try and get you the other stuff tonight (more likely tomorrow).
|
| 10 | philflyboy
ID: 1011562618
Fri, Sep 21, 22:32
|
that would be fine thanks again
|
| 11 | biliruben
Sustainer
ID: 3502218
Wed, Oct 03, 18:24
|
buttiful.
|
|
|
Post a reply to this message:
|