| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Logon | New Users to Excel | |||
| logon | Excel Discussion (Misc queries) | |||
| Logon Screen | Excel Worksheet Functions | |||
| NT Domain Logon | Excel Programming | |||
| Logon to Worksheet | Excel Programming | |||
Linear Mode
