J
jumbuck
The installation program for our software checks the Excel and Visio
versions to determine whether to install our PIAs ( to provide .NET
Programmability Support). Some customers have observed Excel crashing
during the installation (Microsoft Office Excel has encountered a problem
and needs to close...)
Via virtual machine, we have boiled the crash down to the MS Office Live
Add-in 1.3 made available on Windows Update in March and continuing with the
1.4 version available in June and can demostrate it with the VBA code shown
below. We additionally wrote a brief VBScript but to date have not caused
the crash. We can crash both Excel 2003 and 2007 in this way.
Are others observing this problem, and to what forum or escalation path can
I proceed to achieve a resolution ?
Ideally we would want this problem to be reviewed by the same team that
produced KB969144. http://support.microsoft.com/default.aspx/kb/969144
=== VBA Code demonstrates Excel Crash (Run in Word or Visio)
(The 1.3 add-in was observed to crash Excel maybe 3 or 4 times in the for
loop, but the 1.4 add-in is much more consistent!)
Option Explicit
Sub tt()
Dim i As Integer
For i = 1 To 10
Debug.Print i,
test
Next
End Sub
Sub test()
Dim o As Object, dTimer As Double
Set o = CreateObject("Excel.Application")
Debug.Print o.Name, o.Version,
Set o = Nothing
dTimer = Timer
Do While Timer - dTimer < 5.0
DoEvents
Loop
Debug.Print Timer - dTimer
End Sub
=== VBScript no issue
Option Explicit
Dim oXL, i, dTimer
for i = 1 to 10
Set oXL = WScript.CreateObject("Excel.Application")
msgbox i & " - " & oXL.Version
Set oXL = nothing
dTimer = Timer
do while Timer - dTimer < 1.5
loop
next
versions to determine whether to install our PIAs ( to provide .NET
Programmability Support). Some customers have observed Excel crashing
during the installation (Microsoft Office Excel has encountered a problem
and needs to close...)
Via virtual machine, we have boiled the crash down to the MS Office Live
Add-in 1.3 made available on Windows Update in March and continuing with the
1.4 version available in June and can demostrate it with the VBA code shown
below. We additionally wrote a brief VBScript but to date have not caused
the crash. We can crash both Excel 2003 and 2007 in this way.
Are others observing this problem, and to what forum or escalation path can
I proceed to achieve a resolution ?
Ideally we would want this problem to be reviewed by the same team that
produced KB969144. http://support.microsoft.com/default.aspx/kb/969144
=== VBA Code demonstrates Excel Crash (Run in Word or Visio)
(The 1.3 add-in was observed to crash Excel maybe 3 or 4 times in the for
loop, but the 1.4 add-in is much more consistent!)
Option Explicit
Sub tt()
Dim i As Integer
For i = 1 To 10
Debug.Print i,
test
Next
End Sub
Sub test()
Dim o As Object, dTimer As Double
Set o = CreateObject("Excel.Application")
Debug.Print o.Name, o.Version,
Set o = Nothing
dTimer = Timer
Do While Timer - dTimer < 5.0
DoEvents
Loop
Debug.Print Timer - dTimer
End Sub
=== VBScript no issue
Option Explicit
Dim oXL, i, dTimer
for i = 1 to 10
Set oXL = WScript.CreateObject("Excel.Application")
msgbox i & " - " & oXL.Version
Set oXL = nothing
dTimer = Timer
do while Timer - dTimer < 1.5
loop
next