View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chad chad is offline
external usenet poster
 
Posts: 273
Default 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")