Launching Excel




A product that I work on uses the following code to check if Excel is
installed. It runs inside a client-side ActiveX control hosted by
Internet Explorer. The client OS is Windows 2000 of course.

Function ExcelFound() As Integer
On Error GoTo ErrorHandler

Dim xlObj As Object

Set xlObj = Nothing
Set xlObj = CreateObject("Excel.Application")
If xlObj Is Nothing Then
ExcelFound = 0
Else
ExcelFound = 1
End If
Set xlObj = Nothing
Exit Function
ErrorHandler:
Set xlObj = Nothing
ExcelFound = -1
End Function

For certain machines and certain users, the check fails even though
Excel is installed. On one such machine, I checked the DCOMCNFG
settings for Excel. It is set to run as the launching user and uses
the default security settings. The default security settings give
access and launch permissions to "INTERACTIVE" and no other groups.
If I explicitly give launch and access permissions to the user, then
the check for Excel works.

As far as I know this is the user's personal machine in his office, so
he's not logging in through Terminal Server.

Any suggestion as to why he didn't get permission via the INTERACTIVE
user principal? If not, are there any diagnositics that I should ask
the customer to run?

Thanks

.



Relevant Pages

  • RE: Ghostly presence of Excel process
    ... referencing to your Excel objects. ... That may be why blXLRunning = IsExcelRunning is always true. ... Set xlObj = New Excel.Application ... Dim WkSht As Excel.Worksheet ...
    (microsoft.public.access.modulesdaovba)
  • Re: Ghostly presence of Excel process
    ... I'm slowly discovering how many ways one can "close" Excel ... If Not blXLRunning Then ... Set xlObj = New Excel.Application ... Dim WkSht As Excel.Worksheet ...
    (microsoft.public.access.modulesdaovba)
  • Re: Ghostly presence of Excel process
    ... MsgBox "Excel is still running!!!" ... Set xlObj = GetObject ... The IsExcelRunning function code is below: ... The problem is caused by incomplete object referencing to your Excel objects. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Ghostly presence of Excel process
    ... MsgBox "Excel is still running!!!" ... Set xlObj = GetObject ... The IsExcelRunning function code is below: ... referencing to your Excel objects. ...
    (microsoft.public.access.modulesdaovba)