Posts Tagged ‘Visual Basic’

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.