Schedule Excel to Update
 

Hello.


I was trying to figure out the best way to 'schedule' a spreadsheet(s)
to update.


I have a bunch of spreadsheets that consist of a pivot table linked to
Access. I need to update these spreadsheets once a week and don't want

to go into each one separately. I was hoping I could schedule a task
to update the workbooks while I'm not at work. My initial thought was
to create a new worksheet that has some code that opens the
spreadsheet, updates the data, closes the spreadsheet and then moves on

to the next. The problem is that I get prompted to Enable Macros and
the scheduled task cannot continue without user interaction. The only
workaround I could think of would be to set the Security Level of Excel
to Low before I leave at night and then turn it back up to Medium when
I come in the next morning.


Does anyone have any suggestions that would allow me to update a
spreadsheet on a weekly basis or during the night without needing user
involvement, given the fact that the spreadsheets have Macros within
them.


Any help or suggestions are appreciated