| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel user enter a store # to query Access data base | Excel Discussion (Misc queries) | |||
| store inventory sheet(ex:sports equipment store) | Excel Worksheet Functions | |||
| Store Excel Results in Access | Excel Discussion (Misc queries) | |||
| Access data base is able to store any number of records | Excel Worksheet Functions | |||
| Unsing names to store input from Userforms | Excel Programming | |||
Threaded Mode
