Arena.Xlsm Version 1.2 Preview
Arena.Xlsm version 1.2 is in the works and it is a major content update. Here are some of the main things to look forward to!
New Tiles: Bottomless Pits and Cracked Terrain – Bottomless Pits are pits of certain death. You want to avoid these! Cracked Terrain are weak terrain that has cracks in it. This will break and turn into a Bottomless Pit when walked on or shot at. The new terrain is being integrated into the rest of the game in the form of new arenas, new enemy types that take advantage of the terrain, and new spell effects. Here is a sample showing one of the new arenas with new challenges that uses all of the different terrain types in Arena.Xlsm:
I’m also looking at: spell balancing, combat balancing (melee attacks can now attack first!), cosmetic changes, new collections, collection completion rewards, and bug fixes!
Another feature that I am looking to implement for version 1.2 is to import game data from an earlier version of the game (such as version 1.1b) so that players can continue their adventure in the latest version without losing any of their progress or achievements.
In order to do this, I need to create a macro that lets the player navigate to their old game, then copy 3 worksheets: “Game”, “Achievements”, and “Variables” from the old workbook into the new workbook. Then replace data in the new workbook with the copied worksheets. I am having some difficulty on the middle part of copying the worksheets from the old workbook into the new workbook. So I’m asking the community for some help, particularly those of you who are better with VBA than I am! If you know how to do this, please send me a workbook that includes a macro that can copy the worksheets from another workbook into the current workbook. Note that it should be able to work with the following code to get the old workbook:
Dim UserPath As String UserPath = Application.GetOpenFilename(“Arena.Xlsm Files (*.xlsm),*.xlsm”, , “Select a file to Import”, , False) If you can help me with this you will have: My sincere gratitude, a credit in version 1.2 as “VBA Coding Support”, and version 1.2 released sooner to everyone as I can save time from failing at this repeatedly!
Edit 4/11/13: VBA Guru Grant Lemasters has graciously volunteered with a solution to this problem! 😀
Thanks! Please let me know what you think about the upcoming changes and if there are things that you want to see make it into version 1.2!
Regarding the release timeline: All of my assignments in all of my classes are due this week, and next week I have final exams. So… no promises but I love you guys and want to get this out as quickly as I can! 🙂
Edit 4/19/13: More photos and details about Version 1.2 are available here: Arena.Xlsm Version 1.2 Progress Update