Oracle ODBC driver password

C

Chad

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
Multiple queries 0
Refreshing Web Queries and DisplayAlerts 3
ComboBox.Enable giving error on ActiveWorkbook.RefreshAll 10
stop running code 1
Excel Query of Access Q 0
Accept & Use ODBC Login 3
insert into oracle commit 0

Top