>Assuming an excel file exists,does anyone know how to tell whether a particular sheet (name) exists, without opening the Excel File ?Steve,
Personally, I would just open the workbook file via automation and loop through the worksheets collection to see if the sheet in question is there or not. Probably easier that way.
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer