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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
Dev Ashish's Late-binding Automation error on fIsAppRunning()? 2
Creating Command Buttons from VBA - adding code 3
Automation to Excel leaves Excel open until Access closed 4
inlineShape.OLEFormat.Activate() command fails for excel file 0
more excel automation trouble with ms access 1
? Save XL TransferSpreadSheet file; For Next not working in Automa 10
Late binding to Excel from Access causing Object error 4

Top