Powerpoint 2007 Add-in problem

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
 
A

Austin Myers

I know you don't want to hear this but Microsoft has changed the patches and
"security" things so much its driving developers nuts. (It has for us.)
Unfortunately for all users Office is like a wire fence trying to stop
running water and they just keep piling one layer of fence wire on the last
one and it takes the hackers about 30 minutes to hack it. The end result is
the hackers have free rein while developers trying to do things the right
way suddenly find their add-ins failing with each service patch.



Austin Myers


Creators of PFCMedia and PFCPro
 

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