I need to use a macro to pull values from cells in a closed workbook and i
can't seem to get it right. I basically have a variable for the directory
path and another for the file name. How do I go about getting a value from a
cell in that workbook and putting it into a predetermined cell in an open
workbook?

I think this is what you are looking for:
http://www.rondebruin.nl/ado.htm

If that's not it, look in this list (the link listed above came from here):
http://www.rondebruin.nl/tips.htm


Regards,
Ryan---

--
RyGuy


"Dave L" wrote:

I need to use a macro to pull values from cells in a closed workbook and i
can't seem to get it right. I basically have a variable for the directory
path and another for the file name. How do I go about getting a value from a
cell in that workbook and putting it into a predetermined cell in an open
workbook?