If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
automatically update several excel spreadsheets
Hello, I have several excel spreadsheets linked to an ms access database. The excel spreadsheets needs to be updated prior running the access database so it uses the latest data. Normally I do this be opening and then saving the spreadsheets. The spreadsheets have names like TIMASTER ACCESS, SERVHIST ACCESS, etc. Is there a way I can do this automatically by doing only one or two actions instead of opening and closing numerous spreadsheets? Regards, Rob -- Rob Rozema |
Thread Tools | |
Display Modes | |
|
|