Just wondering what your trying to do?
If you want to see a specific setup just load it into TripleA.
AAG1940 Banking Program (Excel Spreadsheet)
-
My only suggestions are to add a legend for the macro commands so you can see what they are on the screen, and add purchase options for purchasing back damage, buying technology, or upgrading a minor to a major factory (20 IPCs).
Looks great man, I’ll start thinking/using this and see if I can come up with some scripting that may help it along. (ie like making the macros into buttons you click).
-
Hey, great code on this! I added buttons real quick to eliminate the need for hotkeys. (Sorry, but I already started customizing the colors and fonts on mine, too!)
I never would have thought to do this, but this is awesome! This runs great if you take the headings off and run it full screen in Excel. Thanks again!
-
Thanks for the suggestions, Hamster. I was thinking about adding a “misc” row to the purchase sheet where you could just enter in the amount. I think that would take care of everything.
Nice changes, bcguitars. I like the colors a lot, and the buttons are awesome. There should be a warning before reseting though, because I could see myself hitting that by mistake. I can put that in the next version.
-
Can anyone out there use this to program the macros for use on a Mac? I simply don’t know how to do this. The file will display for me, it’s just not able to “run visual basic macros”. Thank you in advance.
-
Hey Variable,
All of the macros I wrote use Visual Basic for Applications (VBA), a very Microsoft-y programming language. I’m not positive, but my guess is that VBA is not compatible with Macs. You may be out of luck, sorry…
-
Variable, what program are you using to open the spreadsheet? Office 2004 for Macs supports VBA, but Office 2008 does not. Microsoft has said that the next version of Office for Mac will support VBA again, but if you’ve got 2008, you’re SOL.
-
Can anyone out there use this to program the macros for use on a Mac? I simply don’t know how to do this. The file will display for me, it’s just not able to “run visual basic macros”. Thank you in advance.
I have a MacBook loaded with Office 2008 and the VBA macros do not work with that software version.
-
2008 for me. Guess that = SOL…
-
-
I get the error message "Invalid or Deleted File. " when I try to download version 2.0.
-
I also have the latest macro-enabled Excel spreadsheet available if anybody wants that. It keeps track of Income, Bonuses, and Banks and has a calculator for unit purchases. It also archives the banks at the end of each turn and creates a graph, so you can review the progress of each country in the game.
-
Nice.
-
Is the spreadsheet up to date with 2e rules?
Suggested Topics
