On Sun, 24 Sep 2006 15:54:33 -0400, "RFraley" wrote:

I have a VBA routine (XL2003) that scans the harddrive for workbooks with a
certain pattern (first 4 charac ters of name = "CLSd") in the filename. I
am currently using ExecuteExcel4Macro to read data from each of these
workbooks without having to open each one.

ExecuteExcel4Macro? But xl2003 is Excel 11.

When I want to read a cell from a closed workbook without opening it, I
have my VBA create a link in a cell to a cell or range in the closed
workbook. Then the VBA changes the cell to a value with
Range("xx").Value=Range("xx").Value. But we don't have password protected
workbooks, so I have no idea how this will work with them.

Don <www.donwiss.com (e-mail link at home page bottom).