Application.Tasks property (Word)
Returns a Tasks collection that represents all the applications that are running.
expression An expression that returns an Application object.
For information about returning a single member of a collection, see Returning an object from a collection.
This example displays the calculator. If the calculator is not already running, then Word starts the task and then displays the calculator.
If Tasks.Exists("Calculator") Then With Tasks("Calculator") .Activate .WindowState = wdWindowStateNormal End With Else Shell "calc.exe" Tasks("Calculator").WindowState = wdWindowStateNormal End If
This example checks to see whether Microsoft Excel is currently running. If the task is running, the example activates Microsoft Excel; otherwise, a message box is displayed.
If Tasks.Exists("Microsoft Excel") = True Then With Tasks("Microsoft Excel") .Activate .WindowState = wdWindowStateMaximize End With Else Msgbox "Microsoft Excel is not currently running." End If
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.