Hi,

This is what i am trying to do. Not being very familiar with excel i am not sure if this can be done.

I want to connect to an access database. The password of which would only be known to the user. So i have to create a connection string at run time. I have done similar stuff in VB.NET but not extremely sure how to do it in excel...

Thanks !!