Excel Presence

[Jim Heavey]

Is there a way to determine if Excel is loaded on the machine?

Is there a way to tell if excel is associated with a filetype?

 

[Paul Clement]

¤ Is there a way to determine if Excel is loaded on the machine?
¤
¤ Is there a way to tell if excel is associated with a filetype?

Try the FindExecutable API function call:

Declare Function FindExecutable Lib "shell32.dll" Alias "FindExecutableA" (ByVal lpFile As
String, ByVal lpDirectory As String, ByVal lpResult As String) As Int32

Function IsExcelInstalled() As Boolean

Dim DummyFile As String
Dim FileDir As String
Const MAX_PATH As Integer = 255

Dim FilePath As New String(" "c, MAX_PATH)

DummyFile = "e:\My Documents\book1.xls"

If FindExecutable(DummyFile, FileDir, FilePath) > 32 Then
IsExcelInstalled = True
End If

End Function


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)