![]() |
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