how to run a .bat file at specified date

[athlug]

good afternoon all....could someone please assist? here is the case...
i got a macro within a xl file...and another script saved as .bat (like myscript.bat )....
what i need? i need to run this myscript.bat through th excel macro within a specific date......lets say 01/01/2016
could someone help me?

many thanks!!!

[TMS]

Why do you need to run it through Excel. If you have a batch file that you need to schedule, why not just use Windows Scheduler? Either way, you can use Windows Scheduler to load the Excel Workbook which, in turn, would use the Workbook Open event handler to run your Excel VBA macro.

Regards, TMS

[athlug]

well...i'd like not to involve many programs to do the whole work..as far as i got the macro set to run,would be (in my opinion..) easier to add some more functions..like this .bat file............any other ideas?

[TMS]

You could use Application.OnTime to schedule the macro to run and load the batch file. So, if you're ok with having Excel running 24 hours a day, 7 days a week, that'll probably work.

That said, I know you have to keep track of OnTime schedules and use the exact time to stop them, so maybe it stores something somewhere, maybe in the Registry, and it can wake Excel up, open the workbook, and run the macro.

Just seems a bit of an overhead when you have a built in tool to schedule tasks. Still: your choice.

I guess you'll have to experiment with a date and time a little less distant.


Regards, TMS