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:
|