Access query from Excel

[mas]

I am trying to write a query and accesss database. I can query the database
and
return a value to cell on a work sheet, but I would like the value assigned
to variable instead. Can that be done without placing the value on a
worksheet? I use the value in a formula.

Thanks

 

[Jake Marx]

Hi mas,

I am trying to write a query and accesss database. I can query the
database and
return a value to cell on a work sheet, but I would like the value
assigned to variable instead. Can that be done without placing the
value on a worksheet? I use the value in a formula.

Yes, but it will involve some VBA programming. You could hit the db with
ADO, get the value you need, and store that value in a variable. You can do
a google search or MSDN search on ADO to find tons of examples of how to do
it.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]