Automating

  • Thread starter Thread starter Marek
  • Start date Start date
M

Marek

Hi,

I have 8 Excel Spreadsheets that gather data from an External Data Source.
I'd like to somehow schedule these files to open, refresh the data, and then
close some stage at night so the data is fresh for when the user gets in.
(it takes about 5 minutes to update each workbook).

Does anyone have any ideas?

Thanks

Marek
 
Marek said:
Hi,

I have 8 Excel Spreadsheets that gather data from an External Data Source.
I'd like to somehow schedule these files to open, refresh the data, and
then close some stage at night so the data is fresh for when the user gets
in. (it takes about 5 minutes to update each workbook).

Does anyone have any ideas?
Click to expand...

Chron for *ix or Windows' scheduler should work just fine.
 
Did anyone get an answer to this question? I'm having the same issue. My
files are NOT set to refresh upon opening on purpose so using Windows
Scheduler doesn't help me.
 
Back
Top