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?
|