View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Muriel Muriel is offline
external usenet poster
 
Posts: 2
Default Store sheet names in Access

What I'm trying to do is the following. I have a huge Excel spreadsheet with
many different sheets. I would like to keep track of all the sheets that I
have. So, I would like to store these spreadsheet names in an Access
database.

Every time I open the file, then Excel will check all the sheets to see if
any has been added. If so, it will add the spreadsheet name in the database.
If any sheet names were changed or deleted, it will modify the database
accordingly.

Any help on how I could accomplish that?