CODE VBA CHECK THE PROGRAM RUNNING

[Excelpromax123]

Hello everyone. I need a VBA code to check if a program is running or not. If run is True otherwise False. For example, I want to check the program "GoogleDriveFS.exe", so that I know if it is not running I have to open it. Thank you

 

[Jaafar Tribak]

Should be easily done with the WMI service.

Here is this function:

Public Function IsPrrogRunning(ByVal Process As String) As Boolean
    Dim objWMIService, colProcesses
    Set objWMIService = GetObject("winmgmts:")
    Set colProcesses = objWMIService.ExecQuery("Select * from Win32_Process where name='" & Process & "'")
    If colProcesses.Count Then
        IsPrrogRunning = True
    End If
End Function

Usage example:

MsgBox IsPrrogRunning("GoogleDriveFS.exe")