automatically update several excel spreadsheets
This may be a bit off topic, but if all you need do is open and close files,
it could be worth looking at windows scripts. I use them in many ways, the
beauty is that once set up they only need a double click, or even setup to
run when you start your computer, or as you start your database.
Regards Steve
"Rob Rozema" wrote in message
...
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
|