| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I pass the logon credentials in a macro to a ODBC query
I have a spreadsheet with query to an ODBC data source
Each time the spreadsheet is opened and query refreshed it prompts for the USERNAME an PASSWORD which in this instance are both blank. Is there a way to pass the logon credentials in a macro? or other way of avoiding the prompts? Thanks -- Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I pass the logon credentials in a macro to a ODBC query
If you're using MS Query, you can save the password in the query using
the External Data Range dialog. Cliff Edwards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I pass network logon name to a cell in a spreadsheet? | Excel Worksheet Functions | |||
| Can a service account be embedded in Workbook so that by default the macros are run with service account credentials and not the user credentials??? | Excel Discussion (Misc queries) | |||
| Pass Combo Values to an ODBC Parameter........ | Excel Programming | |||
| Problem with .Background Query option of ODBC Query | Excel Programming | |||
| SQL query to ODBC | Excel Programming | |||
Linear Mode
