Create a new worksheet in the receiving workbook.
Open your sending file.
Select the cell in the sending worksheet in the sending workbook.
Edit|Copy (or ctrl-c)

Back to A1 of that new worksheet in the receiving workbook.
Edit|paste special|paste link

Close the sending workbook.

Now back to the receiving workbook.

Start recording a macro.
Select A1 of that new sheet
Hit F2 (to edit the cell)
Hit Enter (don't make any changes)
Stop recording the macro.

Your recorded macro will have the syntax building that formula. Depending on
the names of the paths/folders/workbooks/worksheets and addresses, you'll want
to match that syntax when you build the formula using variables.

If you have trouble, share the exact recorded formula and your variable names
and what they represent.

Robert Crandal wrote:

Can you give an example of adding "formulas to empty cells to retrieve
values from
your sending workbook"???

Additionally, I discovered that the GetValue() function mentioned below DOES
work very well for reading individual cells. However, if I want to read a
range
of cells (say "A1:L25") then my code starts to look ugly. It is also a very
slow process of reading a range of cells one cell at a time by calling
GetValue() for each individual cell. Can GetValue somehow be used to
read a range of cells in a faster manner???

As for the GetDataFromClosedFile() function, it seems to be missing function
parameters, so I have no clue how to use that one.

Hope to hear from you soon! Thank you!

"Dave Peterson" wrote in message
...

You could add formulas to empty cells to retrieve values from your sending
workbook.

=======

John Walkenbach has a routine that can get values from a closed workbook:
http://j-walk.com/ss/excel/eee/eee009.txt
Look for either: GetDataFromClosedFile or GetValue.

=======

--

Dave Peterson