Schedule A Macro To Run With Scheduled Tasks

[Carmelo Labadie]

I have a worksheet that runs a query from an external data program. I have made a macro that refreshes the worksheet and this works ok. Is there a way I can get Scheduled tasks to automatically update this workbook eg overnight. I do not want to leave the workbook open either. Can task scheduler open the workbook, refresh the data, then close the workbook again.


Please help

Thanks

[Dorian (MJT support)]

Yes of course.

Simply open it with XLOpen (as you may already be doing), and after it's finished processing use XLSave and XLQuit.