Hi mike

Open the workbooks is also fast and you have more control.
http://www.rondebruin.nl/copy3.htm

See also the ADO page
http://www.rondebruin.nl/ado.htm

John Walkenbach have some information on this page
http://www.j-walk.com/ss/excel/tips/tip82.htm




--
Regards Ron de Bruin
http://www.rondebruin.nl


"Mike Mertes" wrote in message ...
I can't seem to find any functions I can use to retrieve data from cells in
workbooks that aren't open.

I'm familiar with links, DDE, OLE, etc. But, I only know how to link with
spreadsheet formulas rather than VBA code.

Can someone point me in the right direction?

TIA!
--
-Mike Mertes
Airtron, Tampa Bay