See
http://www.rondebruin.nl/copy3.htm

Or add a link to the cell
http://www.rondebruin.nl/summary2.htm


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


"DRK" wrote in message ...
I need to get the value in cell C5 of many workbooks. Basic idea is cell C5
contains the status of a project and we want a listing of each workbook by
name and its status.

The folder contains 50 or so workbooks. In each workbook I'm assuming
Worksheet(1) is the current sheet.

Any suggestions would be appreciated.
--
DRK