Harlan corrected me on this one, too. I once posted that it starts another
instance of excel and opens the other file there and retrieves the value.

Actually, it uses the same techniques that John Walkenbach does to retrieve a
value from a closed workbook.

But it wouldn't be necessary to use Harlan's routine in a case where the macro
itself will retrieve the value.

To the OP: Harlan's routine is very nice when called from a worksheet where the
closed workbook can vary (based on another cell--and =indirect() would be used.

And in the most basic sense, I guess I agree with You and Keith--just use a
formula in a cell that would point to the cell you want to retrieve.



Tom Ogilvy wrote:

without opening it?

I believe that opens the workbook, Dave.

Maybe suggesting John Walkenbach's method, or use of ADO or simply putting a
link in a cell (fastest) would be more appropriate.

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
Harlan Grove posted a function that opens another instance of excel and
then
retrieves the value from that closed workbook.


http://google.com/groups?threadm=oZx...wsra nger.com

Joe B. wrote:

Does anyone know the code to use to be able to pull data from a closed
workbook, without opening it?

--

Dave Peterson


--

Dave Peterson