Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel program be or not in computer
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel program be or not in computer
thank you, NickHK I wanted it, your answer. good bye. *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My computer keeps speaking out cells in excel, no other program | Excel Discussion (Misc queries) | |||
Fatloss computer program | New Users to Excel | |||
What program do I need to download clip art onto my computer? | Excel Discussion (Misc queries) | |||
Excel program only runs on one computer | Excel Programming | |||
move excel program from old computer to new | Excel Discussion (Misc queries) |