How to tell if a worksheet exist in a workbook

[LonnieJohnson]

I have an access application that opens an excel workbook that has about 10 worksheets and writes data to each worksheet.

I have a query that has a corresponding record for each worksheet. Sometimes there is an extra record or two that do not have a corresponding sheet and they overwrite the data that is in the sheet.

My question is how can I tell if a worksheet exist in an excel workbook via vba?



ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[Remou]

You can open the workbook via automation and check the worksheets collection.