Access 2010 VBA Read Excel file sheet name. I have an export process that transfers data from my Access tables to an Excel File.  A couple times I have had issues where the process didn't generate one or more of the sheets (1 sheet = 1 table) in Excel. So when the transfers are complete I want Access to check if all the sheets are located in the Excel file. I have most of the Check process worked out all I need now is a way to "read" the sheet names from the Excel File in to a table. Is there anyone who knows of a way to read the Sheet name (not the data)?

---

Reply from Richard Rost:

I couldn't tell you how to do this off the top of my head. I'd need to research it for you and experiment. If you're stuck, you can submit the question via TechHelp and maybe one of my guys can work up a solution for you.