Archive

Posts Tagged ‘Excel’

Excel goodness

May 26, 2010 Leave a comment

Who would have thought that you could build a complete game using Microsofts Excel & VBA scripts? I surely didn’t, but after spending just 1 day I discovered you could.

While the game obviously won’t be state of the art, it’s still impressive at just how flexible Excel actually is.

Visual Basic & Microsoft Excel

March 2, 2010 Leave a comment

I’ve spent the last couple months really digging into Microsofts excel and I have to say it’s amazing. I recently found out it shipped with a version of Visual Basic and I began constructing Gui based spread sheet editors that really turned out nice.

However the more I use the visual basic scripts the more I realize that it’s just that. A script. It’s missing the power that the .Net based visual basic provides and really makes developing with it a pain. With that having been said though, I must give it to Microsoft; no Internet & no previous experiance with excel scripting & I was able to write a several hundred line script that manipulates my spreadsheets(removing/editing /injecting rows & data) simply by refering to their included documents.

It’s hard to find products now-a-days that include documentation that works great when offline.