Quote:
Originally Posted by EricH
I will note that I'm actively working on another version of the drafting program, this one based in Excel and its macro codes. So far, though, I really only have the randomization functions (players and teams) working; teamlist pulling is available but I don't know how to get it fully functional (AKA automatic given an event code); and I'm working on splitting tiers up based on # of teams and # of players (the code isn't really crashing yet, but I still actually have to do the split). Means I have a bit of a todo list--if you think you know more Excel VBA than I do, I might be needing some help before long. (I do have some loose algorithms; let's just say I used similar ones on the C++ version about 3-4 years ago.)
|
Adding a datasource in Excel with VBA is a little tricky. I've been trying to do it for a while, but I haven't had time to get deep into it. I know it has something to do with creating a Connection and adding it to the QueryTable.
- Sunny G.