Run a .bat file every 10 min

[mattd4385]

Use excel to:
Run a .bat file every 10 min until excel is closed or macro is stopped.


This is what the .bat file is doing it would be cool if it could also be done in excel without having to use a .bat file...

Pull the newest file (only one File) from a Folder Say "C:\Documents and Settings\All Users" and copy to a new location Say "C:\Temp"

 

[Domenic]

Maybe something like this... Run the 'CopyFile' macro to copy the file and schedule the macro to run every 10 minutes. Then, run StopCopyFile to end this process.

[font=Verdana][color=darkblue]Dim[/color] dt [color=darkblue]As[/color] [color=darkblue]Date[/color]

[color=darkblue]Sub[/color] CopyFile()
    [color=green]'Your code here[/color]
    dt = Now + TimeValue("00:10:00")
    Application.OnTime earliesttime:=dt, procedure:="CopyFile"
[color=darkblue]End[/color] [color=darkblue]Sub[/color]

[color=darkblue]Sub[/color] StopCopyFile()
    Application.OnTime earliesttime:=dt, procedure:="CopyFile", Schedule:=[color=darkblue]False[/color]
[color=darkblue]End[/color] Sub
[/font]