Run a Btach file from excel

[Macdave_19]

Hi All.

Just wondering how i would call a batch file from excel at a given time say 6pm every day?

any help is really appreciated

My Batch file is located in C:\My Documents\Batch1

cheers

[Kenneth Hobson]

You can use OnTime to run a Sub. Use Shell to execute the BAT file.

I would just put the BAT file in a Windows Scheduled Task and skip Excel.

[Macdave_19]

Thanks for the ideas ken obvious and plausable lol!! why do they always seem such tough problems until you see the answer?

ha ha

[dominicb]

Good afternoon Macdave_19

Just for completeness, this post deals with running .bat files from Excel (oddly enough, it was responded to by myself and Kenneth Hobson again) :

http://www.excelforum.com/excel-prog...-txt-file.html

HTH

DominicB