excel program be or not in computer

[x taol]

i want to know whether setting excel program in the current computer
using vba.

function bln_excel_is_be() as boolean
~~~~~~~~~~
msgbox "yes or no"
end function

*** Sent via Developersdex http://www.developersdex.com ***

 

[NickHK]

Not sure what you mean.
VBA has to run inside an application. As this is an Excel NG, it's assumed
you are running Excel VBA. As such Excel is installed.
But in Word, Access etc you use this to see if Excel is available :

Dim XLApp as Object
set xlapp=createobject("Excel.Application")

if xlapp is nothing then exit sub

Or may be check some registry keys :
HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel

NickHK

 

[x taol]

thank you, NickHK
I wanted it, your answer.
good bye.

*** Sent via Developersdex http://www.developersdex.com ***