Hi,
I run a macro that updates external data via ODBC from a Superbase
database and then performs calculations on the data. The database is
protected through a password that has to be entered in a dialog box
each time a table is to be accessed. Typically, the password is
entered 5 times in one macro and the password is always the same.

In recording a macro, nothing is saved to the macro from the exercise
of entering the password. Is there a way to do it "by hand" in VBA,
i.e. typing code? (Excel 2003)


---
Message posted from http://www.ExcelForum.com/