Excel Spreadsheets? - Fantasy Football Cafe 2014 Fantasy Football Cafe


Return to Football Talk

Excel Spreadsheets?

Moderator: Football Moderators

Postby Amazinz » Thu Jan 04, 2007 4:36 pm

aaawall91 wrote:for instance saving the Macro, I had to save it as a whole file, so like the file type was a 'Excel Macro-Enabled Workbook' which I think is fine but not sure.

I have not actually used the new version only the new VSTO. But of what I know that should be fine. VBA is no longer the primary code-behind in '07 and I believe it does that just to differentiate.

aaawall91 wrote:And I made the short-Cut key Z, however when I go to use it, it gives me the error "You must have exactly two areas to swap. You have 1 areas." I'm not sure what I did wrong.

The error is from the macro itself. You can actually see that text in the macro if you look above. Anyway, here it is in a nutshell: you need to select complete 'areas'. If you want to swap two rows you have to select the entire two rows. If you select three rows or partial rows you will get that error.
Image
Amazinz
General Manager
General Manager

User avatar
Mock(ing) DrafterEagle EyePick 3 Weekly Winner
Posts: 2552
Joined: 16 Mar 2004
Home Cafe: Baseball

Re: Excel Spreadsheets?

Postby rockwell81 » Tue Jul 03, 2007 4:22 pm

Does anyone know of a way on yahoo to import more than 25 players at a time with stats? I can import the entire draft list at one time, but it doesn't include stats.
rockwell81
Water Boy
Water Boy

User avatar

Posts: 56
Joined: 3 Jul 2007
Home Cafe: Football
Location: The opposite of somewhere else.

Re: Excel Spreadsheets?

Postby Amazinz » Tue Jul 03, 2007 5:03 pm

Record the web query as a macro then adjust it so that it runs in a loop. You'll just need to update the Yahoo URL each time through.
Amazinz
General Manager
General Manager

User avatar
Mock(ing) DrafterEagle EyePick 3 Weekly Winner
Posts: 2552
Joined: 16 Mar 2004
Home Cafe: Baseball

Re: Excel Spreadsheets?

Postby haveuseenm » Sat Jul 07, 2007 12:49 pm

Ama your the man
haveuseenm
Cheerleader
Cheerleader


Posts: 22
Joined: 6 Jun 2006
Home Cafe: Baseball

Re: Excel Spreadsheets?

Postby ngub12 » Mon Aug 13, 2007 1:54 pm

what URL are you guys importing player stats from?
ngub12
Defensive Assistant
Defensive Assistant

User avatar

Posts: 603
Joined: 9 Oct 2003
Home Cafe: Football
Location: Buffalo, NY

Re: Excel Spreadsheets?

Postby cosmokid » Mon Aug 13, 2007 2:40 pm

when i try and convert a web page to excel i get a message that there is no data to import.

i bring up the web query, let excel do its thing, then click "import" and get a message that there is no data.

any ideas?

i just want to get some of this data imported to excel and i can manipulate it from there.
cosmokid
Water Boy
Water Boy


Posts: 31
Joined: 26 Mar 2007
Home Cafe: Baseball

Re: Excel Spreadsheets?

Postby Amazinz » Mon Aug 13, 2007 2:54 pm

Post the link and I will take a look at it.
Image
Amazinz
General Manager
General Manager

User avatar
Mock(ing) DrafterEagle EyePick 3 Weekly Winner
Posts: 2552
Joined: 16 Mar 2004
Home Cafe: Baseball

Re: Excel Spreadsheets?

Postby West Coast Bias » Fri Sep 14, 2007 6:48 am

This is why my wife does not like me doing fantasy football.
West Coast Bias
Water Boy
Water Boy


Posts: 40
Joined: 25 Aug 2007
Home Cafe: Football

Re: Excel Spreadsheets?

Postby rcktfn » Mon Jul 28, 2008 11:37 am

I know this is an old thread but I just wanted to say thanks. I found this thread using google trying to figure out how to use excel to make a draft board. The import tip was just what I needed to get started. I am no Excel expert, but with a little research I was able to make something we can display on a projector for everyone to see.
There is a drop down list for every position. I pulled a list of players from NFL.com. After you choose a player, he is no longer pickable. You enter the price of the player under their name. The spread sheet keeps track of how much you spent, how much you have left, and how many players you need. It also changes color at the bottom to let you know you are running out of money. Also, if you go over you $100 you are allowed to spend, there is a $25 penalty for every $1. It will calculate that for you.
Try it out:http://www.theaguilars.com/ffl/DraftBoard.xls
rcktfn
Cheerleader
Cheerleader


Posts: 7
Joined: 28 Jul 2008
Home Cafe: Football

Re: Excel Spreadsheets?

Postby andreaburton » Mon May 09, 2011 3:53 pm

hey thanks for the help with excel! :)

Andrea B.

Mod edit: removed advertisement link
andreaburton
Monday Morning Quarterback


Posts: 1
Joined: 9 May 2011
Home Cafe: Football

Previous

Return to Football Talk

Who is online

Users browsing this forum: No registered users and 5 guests

Forums Articles & Tips Start & Sit Sleepers Rankings Leagues


Get Ready...
The 2014 NFL season kicks off in 12:18 hours
(and 41 days)
2014 NFL Schedule


  • Fantasy Football
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact