You can use ADO if you want
http://www.rondebruin.nl/ado.htm

But open it is also a good option

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


wrote in message oups.com...
Hello World,

Is it possible, either through VBA or a formula, to check the value of
cell in a closed workbook if you don't know the sheet name?

All I know is that it will always be the first and probably only sheet
in the Workbook.

Kind regards,
Nick.