This code will check if an Office App is Running. If the App is not running then it opens the App.
Check if Microsoft Word Application is Open
Sub Check_If_App_Is_Open() 'Check if Microsoft Word is Running wApp = "Word.Application" If IsAppRunning(wApp) = True Then MsgBox "Word is Running" Else MsgBox "Word is Not Running" 'Create a new instance Set oApp = CreateObject(, wApp) End If End Sub
VBA Coding Made Easy
Stop searching for VBA code online. Learn more about AutoMacro – A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!