ExcelBanter - View Single Post - Batch file to start multiple excel files with auto_open() macro. Delay code needed

[email protected]

I'm under Win2k

And here's my VA code:

Sub auto_Open()
Application.OnTime Now + TimeValue("00:00:03"), "update"
End Sub

'This is a Datastream update
Sub update()
Sheets("REQUEST_TABLE").Select
Application.Run "autoopen.xls!StartProcessingRT"
Application.OnTime Now + TimeValue("00:00:05"), "Save_Exit"
End Sub

Sub Save_Exit()
ActiveWorkbook.Close True
End Sub