| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Oracle ODBC driver password
I have the following code setup to refresh 20 queries in my Excel file.
These queries pull data from Access. My question is: I have to enter a user name and password for each query, is there a way to store this information in the VBA so I don't have to enter it 20 times? Application.DisplayAlerts = False Sheets("Received-W").Select Range("C8").Select ActiveWorkbook.RefreshAll Application.DisplayAlerts = True MsgBox ("Refresh Complete") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Oracle ODBC Driver Errors | Excel Discussion (Misc queries) | |||
| Help with SQL and ODBC Text Driver | Excel Programming | |||
| Excel ODBC Driver with ADO | Excel Programming | |||
| Connect to Oracle using Microsoft ODBC for Oracle | Excel Programming | |||
| which odbc excel driver is the best? | Excel Programming | |||
Linear Mode
