Ed,

I think you are probably looking towards the functions supplied by DDE,
and in MS Access, help on the the DDE Server, together with the Excel VB
help on DDE Initiate etc, will indicate how to query an Access database
and receive the reply.

I have not used DDE in either Access nor Excel, so am of no further use
to you in this respect, but hope this may help guide your questions.

--

Ed Wrote:
Hello,

I am working with budgets, for each item I have a Name, Unit, and Price
per
unit then I just specify a Quantity multiply it by the Price per unit
and get
a Total...

So far what I have is a Excel sheet with Name, Unit and Ppu, I made it
to a
List, and defined a Name for the item's Name column, so each entry I
add
automatically becomes part of it. Then on another sheet I used Data
Validation to choose from those Names from the List, the Unit and Ppu
are
then taken from the "database sheet" with a VLOOKUP formula and then I
just
enter a Quantity and get a subtotal.

It works great, but I would like to separate the database from the
file, to
make the file lighter and to have other people being able to use it
too. Does
anybody know how to:

A) Take that info from a Access database, so far my attempts copy the
whole
database as a table to the Excel sheet, I would like to have it as I
have it
right now, just not having all the database data inside the Excel file,
or,

B) Take that info from a different Excel file, the problem with that is
that
Data Validation is only allowed from the same file

thanks in advance


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=535409