Logon information
 

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.

Logon information
 

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

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

--
Regards

Juan Pablo González

"fl" wrote in message ...
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.