Testing for Excel

Hi Gang,

My app can export data to Excel. In the Main procedure, I test for the
presence of Excel like this:

Set objExcelApplication = CreateObject("Excel.Application")
If Err.Number = 0 Then
If Not objExcelApplication Is Nothing Then g_boolExcelInstalled
= True
Else
Err.Clear
End If

The other day I installed the app on a computer that does not have Excel
(but does have
an evaluation version that has not been activated) and, on startup, an msi
window came up and asked for the disk so it could install Excel. This is NOT
GOOD.

I'm wondering if there is a better way to test for the presence of Excel.
Thanks for any ideas.

Steve



.

Relevant Pages

  • Re: close excel from VB6
    ... Indeed all well known in Excel land. ... In VBA to do otherwise would cause the app to blow (if the ... MSO app from a VB6.exe or are a MSO addin interfacing with VB6.DLLs. ... learning programming was a good idea because my years of business ...
    (microsoft.public.vb.general.discussion)
  • RE: Ribbon primarily designed to drive sales rather than improve usabi
    ... using a new app or OS you may ... regularly with Excel 2003. ... looking for, can you believe it, edit, replace!!! ... I see there is a tool to customize the ribbon which cost $30 at think ...
    (microsoft.public.office.misc)
  • Re: Prevent multiple instances of Excel from starting
    ... I didn't have any confusion as regards multiple Excel instances vs multiple ... Does your app call Excel to reference a particular file (which may or may ... I don't have some malicious intent on making life difficult by randomly ...
    (microsoft.public.excel.programming)
  • RE: Fastest way to read data to populate combo controls?
    ... the type array the read all in one get. ... Or Using VBA in Excel? ... and the VB app opens that document. ... The Word doc is actually built using a macro in an Excel file. ...
    (microsoft.public.vb.general.discussion)
  • RE: Export options
    ... I'm trying to implement your code in my VB app, and I think it will work - ... - but my VB6 is more than a little rusty, ... to do it from this script anyway. ... manipulates each Excel file using that object's methods etc. ...
    (microsoft.public.excel.programming)
Loading