you could use a technique on John Walkenbach's site:

http://j-walk.com/ss/excel/eee/eee009.txt
Look for either: GetDataFromClosedFile or GetValue.

Max Potters wrote:

Hi,

I'm having a problem with retrieving data from a workbook on another PC,
that is, a network PC. I want to copy some cell values from the network PC,
into a local workbook. I know a simple way to do it, but this needs the
"network workbook" to be open.

I want to access the network workbook and retrieve and store data, but
without opening the workbook!

Please help me. If anything is not clear, please reply and I'll give further
details.

Thanks in advance

Max Potters
The Netherlands

--

Dave Peterson