RoyinUK2000
Board Regular
- Joined
- Mar 26, 2002
- Messages
- 79
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
Roy
Please help
Thanks
Roy