Excel/VBA development platform advice needed

Hello!

I'm developing some contract software for a client. Up until now, the software has been written in REALbasic with a PostgreSQL backend. Now, they want me to incorporate some Excel functionality into the system and I need some advice on how to go about it.

Within Excel 2003, I need to have some data defined user forms. The add-in/macro (or whatever the correct term is), must retrieve records from the PostgreSQL backend (ODBC?), then construct a user form using the data from the database. When OK is clicked on the user form, a worksheet needs to be populated based upon the selections on the form (this wording is also derived from the database).

My question is: Is VBA capable of doing all of this? Or, do I need another development environment from MS? Which version/system will give me the functionality I need to do this job?

I hope that makes sense!

Thanks!
Mark

Welcome to the Forums.

Excel VBA can connect to a database using ADO or ODBC connections. I think the hardest part wil be modifying
the userform dynamically.

VBA is very similar to VB6. Easiest thing to do is to break it down into manageable sections.

If you have VS.NET 2003 available to you then perhaps you may also have access to Visual Studio Tools for
Office 2003 too. This is the most powerful IDE available for automating Office.