Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Finding out whether an Excel sheet exists
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00746237
Message ID:
00746457
Views:
17
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform