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