View Single Post
  #1  
Old May 26th, 2010, 04:02 AM posted to microsoft.public.excel.links
Rob Rozema
external usenet poster
 
Posts: 1
Default 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