Ref. Windows 2000 proff.
Excel 97, Excel 2K

I would like to programmaticaly test more than 1000
excel files for "opening Errors" like ...
1)This file is not in a recognizable format ....
or
2)'File Name.xls' cannot be accessed ....
or Whatever opening error

I think the macro shoul work like this.

for each Excel file in c:/documents
open the file, ( and without the user prompt ... )
if there is an excel error message ...
log file name in bad c:\files.txt
else
log file name in good c:\files.txt
end if
next file

Any Help ? Thanks.

Best Regards.

Robert.