Error msg for function to check if app is running

C

Colleyville Alan

"I saw this snippet of code to test whether an Excel application was running
(it was published by Dev Ashish):

If fIsAppRunning("Excel") Then
Set objXL = GetObject(, "Excel.Application")
boolXL = False
Else
Set objXL = CreateObject("Excel.Application")
boolXL = True
End If


But the line with fIsAppRunning("Excel") on it shows a dialog box with the
error message:
"Sub or Function not defined"

I have seen this code published on several web pages and assume that it is
correct and that the function fIsAppRunning is a legitamate function. Is
this an issue of me not having the proper libraries checked or is something
else going on? What's the best way to fix this?
Thanks
 
Top