Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a way from within an excel macro to check if a program is
running on the computer. I need to check to see if a program is running (which is not a microsoft program) before I execute some code. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If you know that Excel will be running on a WinXP, Win2k, or some other PC
with WMI installed, you could use WMI to get a list of running processes and check for the one of interest. A better solution might be to use Word. Most of the time, a user running Excel also has Word installed on the same PC. The Word application has a tasks collection that will let you check for processes that have their own window. It uses the friendly name that would typically be in the title bar of the application. For example, I could run this from Excel to check if the game solitaire was running on the PC. Sub CheckApps() Set objWord = CreateObject("Word.Application") Set colTasks = objWord.Tasks If colTasks.Exists("Solitaire") Then MsgBox "Someone is playing solitaire" End If objWord.Quit End Sub Steve "L3Tech" wrote in message ... Is there a way from within an excel macro to check if a program is running on the computer. I need to check to see if a program is running (which is not a microsoft program) before I execute some code. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
Checking and IF ? | Excel Worksheet Functions | |||
Checking to see that a CHART exists prior to running a simple command | Excel Discussion (Misc queries) | |||
Add checking | Excel Worksheet Functions | |||
Vba - Checking if running | Excel Programming |