Logon information

[fl]

I can pull data from the a SQL database table into a spreadsheet using
VBA but I have to hard code my user id information such as password to
get it. I want to use a userform to pass the UserID and Password for
the query. Is there a addin that will do that? How do I handle this?
Thanks.

 

[Juan Pablo González]

You can create the userform however you like, if you need help doing that,
try downloading the 'UserformTraining' file from here:

http://www.theofficeexperts.com/downloads.htm