K
Knee
Hello,
I have an odd one...About a dozen users in our Australian office use a
product called 'Aztec Temple' which includes add-in's for office products.
The add-in's pull data from a database on the network to produce graphs and
charts on the fly in (primarily) powerpoint presentations. My users have
reported that at, or around, june 1st 2008, the add-in stopped working.
In working with the developer of the application, we were able to
reproduce the failure by running the following simple macro:
Sub macro1()
' Macro recorded 21/08/2008 by let
'
ActiveWindow.Selection.SlideRange.Shapes.AddOLEObject(Left:=120#,
Top:=110#, Width:=480#, _
Height:=320#, ClassName:="MSGraph.Chart", Link:=msoFalse).Select
ActiveWindow.Selection.ShapeRange.OLEFormat.Activate
With ActiveWindow.Selection.ShapeRange
.Left = 120#
.Top = 109.875
.Width = 480#
.Height = 320.25
End With
ActiveWindow.Selection.Unselect
End Sub
On the australian machines, the line:
ActiveWindow.Selection.ShapeRange.OLEFormat.Activate
causes the following error to be displayed:
Microsoft Visual Basic
Run-time error '-2147188160 (80048240)'
OLEFormat (unknown member) : Invalid request. Could not activate OLE object.
My test machines in the USA and Europe do not exibit this behavior. The
macro works properly and creates a graph.
I've done the 'standard' troubleshooting on these Ausie machines -
reinstalled products, removed KB's that were deployed around the time the
users started experiencing the issues, rebuit the WMI repository (hail mary).
So far, no luck. Any help one this issue would be greatly appreciated!
LBA
I have an odd one...About a dozen users in our Australian office use a
product called 'Aztec Temple' which includes add-in's for office products.
The add-in's pull data from a database on the network to produce graphs and
charts on the fly in (primarily) powerpoint presentations. My users have
reported that at, or around, june 1st 2008, the add-in stopped working.
In working with the developer of the application, we were able to
reproduce the failure by running the following simple macro:
Sub macro1()
' Macro recorded 21/08/2008 by let
'
ActiveWindow.Selection.SlideRange.Shapes.AddOLEObject(Left:=120#,
Top:=110#, Width:=480#, _
Height:=320#, ClassName:="MSGraph.Chart", Link:=msoFalse).Select
ActiveWindow.Selection.ShapeRange.OLEFormat.Activate
With ActiveWindow.Selection.ShapeRange
.Left = 120#
.Top = 109.875
.Width = 480#
.Height = 320.25
End With
ActiveWindow.Selection.Unselect
End Sub
On the australian machines, the line:
ActiveWindow.Selection.ShapeRange.OLEFormat.Activate
causes the following error to be displayed:
Microsoft Visual Basic
Run-time error '-2147188160 (80048240)'
OLEFormat (unknown member) : Invalid request. Could not activate OLE object.
My test machines in the USA and Europe do not exibit this behavior. The
macro works properly and creates a graph.
I've done the 'standard' troubleshooting on these Ausie machines -
reinstalled products, removed KB's that were deployed around the time the
users started experiencing the issues, rebuit the WMI repository (hail mary).
So far, no luck. Any help one this issue would be greatly appreciated!
LBA