detecting if user has excel

[jkw119]

is there a way to see if microsoft excel is loaded on the computer using vb? my program is useless if the user doesn't have excel...

thanks,

jeff

[Rick Bull]

I think you should be able to find the path of excel from the registry in HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\App Paths\Excel.exe if it returns vbNullString they haven't got it. You have to get some registry reading code first though.

[techgnome]

here's another way to do it.....

Dim objExcelTest As Object

Set objExcelTest = CreateObject("Excel.Application")

If objExcelTest Is Nothing Then
MsgBox "You don't have Excel installed."
Else
MsgBox "You do have Excel."
End If