I'm somewhat comfortable writing the VBA, I just dont know how to use it to
connect to my oracle db

"CLR" wrote:

It's not real friendly in that way........you'll have to get into some pretty
intense VBA programming if you want to do much of that..........you might try
going through the steps manually one-time with the Macro Recorder turned on
and see what you get....sometimes it's clear enough to be editable.


hth
Vaya con Dios,
Chuck, CABGx3



"coeus" wrote:

Unfortunately, I can't seem to figure out how to call on values from Excel
cells to insert into the queries written in the Query Wizard.

"CLR" wrote:

You can do Data GetExternalData CreateNewQuery and follow the menus.
You must however, have specific access and Rights to the database or it won't
work.

hth
Vaya con Dios,
Chuck, CABGx3



"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!