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