The QueryMaster file on Debra Dalgleish's website might be a good starting
point for you. The VBA is already done. All you need to do is enter the SQL
(which can reference another cell).

http://www.contextures.com/excelfiles.html#External

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"coeus" wrote:

Hi,
The problem I am trying to solve is acessing an oracle database and excecute
a query through an excel cell.

The query would be as follows: select count(XXX_ID) from XXX.YYY_YYY where
AAA in (Excel cell B2) and CCC in (Excel cell G2);

Is is possible to execute such a query, and capture variable info from
another excel cell?

Thanks for any help!