VBA crashes Excel after installing MS Office Live Add-in 1.3 / 1.4

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top