anyone know how to run a macro at a certain time ever week automatically?
does the ontime method work?
Printable View
anyone know how to run a macro at a certain time ever week automatically?
does the ontime method work?
You need a scheduler to launch it at a given time. I know one came with Win 98 and I use it daily to do routine stuff. Which OS are you using?
windows NT -- so does it run the macro or open the template or how can it work?
For the command line you would simply have suchandsuch.xls and then NT has an association to Excel for xls and it will open Excel and load the spreadsheet. In the spreadsheet you will have under workbook a macro built in that will run everytime the spreadsheet is loaded (sort of like autoexec) but I think it is called on_load (not for sure on that part but I can research it Tuesday). The last few commands in the macro will be a application.saveas and application.quit.