Hi,

I'm using this code to open a database connection using ADODB inside VBA.
What I would like to have is a dialog so that users must enter their
username, password and DSN name. I don't like to have this information
written in the code. I know that I can protect the code but still since there
are several users using the same sheet. It will be easier for me to maintain
it.


Thanks

Public db as new ADODB.Connection

sub test()

db.open "DSN name", "Username", "Password"

......

end sub