Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle logon and data refresh

Status
Not open for further replies.
mal2ty

mal2ty

Technical User
Joined
Jun 25, 2001
Messages
28
Location
US
I'm working with a VBA macro in Excel that refreshes data by using the following command:

Selection.QueryTable.Refresh BackgroundQuery:=False

Before Excel can access the Oracle data, the following prompt is displayed:

Logon to Oracle
User Name:
Password:
Server:

The User Name and Server fields are already filled in, but is there a way to use VBA to automate filling in the Password field?
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question Question
Copy data between SQL and Oracle
Replies
8
Views
2K
remeng
remeng
Andrzejek
  • Locked
  • Question Question
Data Type in ADODB.Recordset
Replies
6
Views
1K
strongm
strongm
Submeg
  • Question Question
Selecting shapes based on its name and then arranging them in a circle
Replies
2
Views
439
Andrzejek
Andrzejek
IcarusHallsorts
  • Locked
  • Question Question
I have a column of data in Column A
Replies
3
Views
717
Andrzejek
Andrzejek
feipezi
  • Locked
  • Question Question
How to pull data from MS Access DB and place on an Excel spreadsheet with WHERE clause?
Replies
10
Views
1K
feipezi
feipezi

Part and Inventory Search

Sponsor

Back
Top