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?
Bookmarks