Can A Macro Start A Closed Excel Workbook?

[rockyw]

Scheduler will not work on our network. Can a macro open a closed workbook? Thanks

 

[bobsan42]

yes.

Application.Workbooks.Open "[I]filename[/I]"

check here for details: https://docs.microsoft.com/en-us/of...tFrameworkMoniker-Office.Version=v16)&rd=true

 

[rockyw]

Could this be set on a timer and run every 6 hours

 

[rockyw]

This works but not on the timer Any suggestions please. Thanks

Sub openBk()
    Application.OnTime TimeValue("00:01:00"), "openBK"
    Workbooks.Open "O:\QACOM\Production Reports\End Line Maintenance Dashboard Master.xlsm"

End Sub

 

[BlueHornet]

Not that I've done anything like this, but if I were going to, then I'd have that set up on a script somewhere outside of Excel, something that's running all the time.

Then the script only has to open the file, which can have a Workbook_Open macro that fires when the file is opened, performs whatever steps you want, and then self-saves and closes, waiting for the next Open event to be fired by the non-Excel script.

 

[rockyw]

Anyone know why this times will not work??

Sub openBk()
    Application.OnTime TimeValue("00:01:00"), "openBK"
    Workbooks.Open "O:\QACOM\Production Reports\End Line Maintenance Dashboard Master.xlsm"

End Sub

 

[Joe4]

Don't have the procedure call itself. Have two different procedures, one for the OnTime call, and one holding the command to perform.
See this here: http://www.snb-vba.eu/VBA_Application.OnTime_en.html

 

[rockyw]

OK that's all very confusing, Ill keep looking thanks

 

[Joe4]

Just look at the first item, 1 Unique ontime action.
I believe that is how you want to structure your code, something like this:

Sub RunOnTime()
    Application.OnTime TimeValue("00:01:00"), "openBK"
End Sub


Sub openBk()
    Workbooks.Open "O:\QACOM\Production Reports\End Line Maintenance Dashboard Master.xlsm"
End Sub

 

[rockyw]

Thank you very much for the code, like the other one this runs when triggered manually but not with the timer. There must be something I need to do yet. Thanks