View Single Post
  #3  
Old May 27th, 2010, 05:02 AM posted to microsoft.public.excel.links
Rob Rozema[_2_]
external usenet poster
 
Posts: 1
Default automatically update several excel spreadsheets


Thanks, Steve. Sounds promising. When I open the Excel spreadsheet I
have to wait awhile ( 10 sec to 5 minutes depending on which
spreadsheet ) so it's data will update from another database. Then I
can save and close again. Can you set this type of scenario with a
windows script ?
Regards, Rob

steve;956160 Wrote:
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 -





--
Rob Rozema