
I've decided to buy a copy of PureBasic for the main 3 platforms. I've written this application in VBA (multiple forms, etc) that manages assets for a medically-oriented department: mine is the recovery unit at the hospital that I work in. The forms simplify managing a fairly large spreadsheet (essentially a large flat-file database, really) containing all the information pertaining to equipment in the department.
The reason I decided it was time to leave Excel and move to a relational DB (I'm looking at SQLite mainly because it is very transportable) is because of the limits of a flatfile dealing with changing (updating) status history on a given device. I cut my teeth on programming in general with FoxPro, so DBMSs are nothing new... have worked with MySQL and SQLServer as well, so I find being able to use SQL statements within the programming environment very appealing, something VBA did not support.
Also, I want to be able to support the 3 main OSes, since I work mostly in Linux and want to support Mac as well as Windows.
I'm wondering about this whole project environment, though... going from like VB6 to PB would seem like less of a step because you'd be familiar setting up the whole application and main form and all of that... all this was managed in VBA within EXcel itself. So, I'm wondering if it would make more sense to try to export my VBA to VB6 first, then PB... or am I wasting my time with VB6?
I do realise that porting a VBA application to PB is going to amount to a complete re-write... I'm prepared to do that.