Excel Oracle connection

[Ucaihc]

I have an Excel app that populates some cells using Microsoft query to get data from an Oracle database. The problem is that when I run the macro that uses the query, I am always prompted for the
Oracle database userid and password. How do I code that in the application so I am not asked for it.
Or, what else can I do so I am not asked for these things?

 

[PHV]

Set the SavePassword property of the QueryTable to True, or right click the data range and modify the relevant property.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886