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
Printable View
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
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.
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