Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to tell if sheet exists in closed workbook
I need to find out if a worksheet named Sheet1 exists in a closed workbook.
A search of news groups suggest you can use ADO to find out sheet names in closed workbooks but I don't need to know the names. I just need to know if Sheet1 exists in a workbook. If it doesn't exist, that workbook is ignored. I have other validation code to screen for improper data on closed workbooks when the name is Sheet1 which is a pretty common name so that part is not a problem. My code for reading data from closed workbooks works fine until a workbook is found that doesn't have a sheet named Sheet1. Then Excel puts up a list of sheet names for the workbook. I haven't coded for this, don't know how and don't want to and even though it creates an error eventually that I handle, it thoroughly confuses Users. I'd sure like to find some way to query the closed workbook to see if Sheet1 exist. An error returned on a workbook without Sheet1 is fine since that can be handled. Ideas would be very greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving Sheet to Closed Workbook | Excel Discussion (Misc queries) | |||
Help - How to check if value exists in closed workbook? | Excel Programming | |||
Check if sheet exists in a closed workbook | Excel Programming | |||
Finding the last row in a sheet in a closed workbook. | Excel Programming | |||
Import Sheet from Closed Workbook | Excel Programming |