Legend of Zelda in Microsoft Excel GamesExcel 2013-03-27 | Version 0.013 of my lunchtime project - Excelda! It's my attempt at recreating the classic Gameboy game, Legend of Zelda Link's Awakening using nothing but Visual Basic in Microsoft Excel. This version is running in Excel 2002 on PC. It also runs in 2007, and should run in 2010 and 2013 although I haven't tested it. It won't run on a Mac, or in OpenOffice/LibreOffice etc unfortunately.I actually started creating it as a bet with a friend who said it couldn't be done. Once I got into it, I quite enjoyed the challenge of creating the underlying engine, with as many reusable components as possible. EDIT: Removed the download link as apparently the file contains a virus. I'll reupload to a better filesharing site if I get the time. I'll have set up an old PC (and run some antivirus!) so don't hold your breath...As a disclaimer there's no sound, and the whole thing is full of bugs and MASSIVELY UNFINISHED. It's playable until just after Link enters the mysterious woods. After that there's not much else to do.From the title screen click 'New game' then use the arrow keys to move around. Keys D and C to use the shield and sword (once you've picked them up), and also trigger the conversation with Tarin to get you out of the first room. The Q key quits at any time. Finally, on the 'Game1' worksheet, you'll probably want to play around with the zoom level and width of column C so that just one 'screen' at a time fits on your monitor - otherwise you might find it scrolls oddly (the numbers in row 2 and column C should help you get it right). Code is all unlocked - feel free to have a poke around. It's messy, and I'm sure there are many better ways of doing it!There is loads more to do - not sure I'll ever have time to finish it though. I did create a sprite drawing tool which you can view/download here: http://youtu.be/PL9lz5_W0Bo Please leave a comment and let me know what you think. If anyone's interested, I'll post some more videos or tutorials, and make the source code available.And in case Nintendo are watching, I don't make any claim to own the copyright to Link's Awakening, no copyright infringement intended. It's just a fan-made snippet of the original, shared to help people understand VBA. I hope it serves as an incentive for people to go out and buy the full game!
Excel Space Wars (R-type clone) GamesExcel 2013-09-23 | This is a vid I discovered lurking on my harddrive of a game I made ages ago. Heavily ripped off from R-Type (great game), this was done mainly to see how many sprites Excel could handle on-screen at any given time without substantial slowdown (at least on my rubbish computer). Quite a few is the answer! And it could probably do more if my code were better...There's no sound and it's pretty boring - skip to about 1:50 to see the first boss appear. You'll see I'm pretty crap at playing it, and never manage to get to the second boss (which is a pink brain thing if I remember right).I've tested it in Excel 2003 and 2007 for PC, but not on the Mac (sorry). I'm pretty sure it won't work in Open/Libre Office. As usual the code is all unlocked - feel free to play around and improve it!
Excel sprite drawing tool GamesExcel 2013-04-01 | It was taking ages to draw sprites for my Excelda game (http://youtu.be/GzC2K-kn31o) by hand, so I created a simple tool to speed up the process. Here's a quick video of it in action.You can download it here?: http://www.4shared.com/zip/46nmvbtH/SpriteDrawer_v004.html (there are a lot of ads that look like the download link, so be sure to click the right one!)It's not perfect by any means, but it allows you to:- Assign the main colour to the left button of the mouse- Assign a secondary colour to the right button of the mouse (this kind of behaves like a 'fill' option, which isn't quite what I wanted, but hey ;))- Assign transparency to either button of the mouse- Select either a 16x16 or 32x32 grid to draw in (it should be possible to allow custom grid sizes, but I didn't need it, so didn't add it) - Draw by left/right clicking anywhere inside the grid- Select ranges when drawing that are filled automatically- Generate a .png image of the drawing- Resize the .png to custom heights/widths as the .png is generated (in Px or Cm)- Resize the .png to custom heights/widths AFTER the .png is generated (in Px or Cm)- Save the drawing (not the .png) to an inbuilt library- Reload the drawing from the libraryIt works fine in Excel 2002 and Excel 2007. In theory it should work in 2010 and 2013 too, but I haven't tested. No idea if it works in OpenOffice/LibreOffice etc, or on the Mac.If you download it, all the code is unlocked - feel free to use/customise however you wish.
