you can use the ONTIME method - read HELP
That works when the workbook is open all the time
If you want it to open , refresh then close, you can set the windows Task
Manager to run the spreadsheet, then have the workbooks Open event refresh
the sheet, then save itself and close
