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 strongm 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
Jun 25, 2001
28
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
Data Type in ADODB.Recordset
Replies
6
Views
384
strongm
strongm
IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
183
Andrzejek
Andrzejek
feipezi
  • Locked
  • Question
How to pull data from MS Access DB and place on an Excel spreadsheet with WHERE clause? 2
Replies
10
Views
280
feipezi
feipezi
monyi
  • Locked
  • Question
Extracting Data from XML Node
Replies
0
Views
108
monyi
monyi
Kymenglish
  • Locked
  • Question
Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups
Replies
3
Views
200
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top