Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
In VBA, check if file is corrupt or not Excel
I'm using Excel 2003.
Using VBA, I am looping through a number of excel files, extracting data from each, and writing that data into another excel spreadsheet. Occasionally, there is a Word document in the directory, and once there was a corrupt Excel spreadsheet. How do I check if the excel file that I'm trying to open is corrupt or not in an Excel format? Your help would be greatly appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Corrupt File | Excel Discussion (Misc queries) | |||
How check if file to open is Excel or if Excel file is corrupt? | Excel Programming | |||
Corrupt Excel File | Excel Discussion (Misc queries) | |||
Corrupt Excel File | Excel Programming |