Add-in VBA issue in one region

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
 

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