Automating

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
 
V

Vanessa

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.
 
Top