View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default excel program be or not in computer

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\Ex cel
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\E xcel

NickHK

"x taol" wrote in message
...


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 ***