ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Oracle ODBC driver password (https://www.excelbanter.com/excel-programming/405542-oracle-odbc-driver-password.html)

chad

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")


All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com