I have a large VBS script that opens thousands of excel files of various types. Some of these files are very old and possibly corrupt.

I have run into some files so far that want to be converted. These files have the exstention of .xls

I even ran a VBS script against the file object of the file and it came up, Type of the file: Microsoft Excel 97-2003 Worksheet.

Attached a picture of the Text import wizard.

excelTextWiz.png

Is there anyway of making the wizard not show, or verifying a file is good before running the code?