Add-in VBA issue in one region

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


.

Relevant Pages

  • Powerpoint 2007 Add-in problem
    ... I have an odd one...About a dozen users in our Australian office use a ... ' Macro recorded 21/08/2008 by let ... Run-time error '-2147188160 ' ... My test machines in the USA and Europe do not exibit this behavior. ...
    (microsoft.public.powerpoint)
  • Powerpoint 2007 add-in returning error on some machines in environ
    ... I have an odd one...About a dozen users in our Australian office use a ... ' Macro recorded 21/08/2008 by let ... Run-time error '-2147188160 ' ... My test machines in the USA and Europe do not exibit this behavior. ...
    (microsoft.public.office.developer.vba)
  • Re: Macro code error; machine dependent
    ... > Have you checked out if the machines throwing the error have printers ... I created a macro which then produces another excel ... > me their entire spreadsheet, ... > VBA, I recorded this macro and tested it thoroughly, and it worked fine. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Macro code error; machine dependent
    ... Have you checked out if the machines throwing the error have printers ... I have created an excel spreadsheet for multiple users which enables them to ... VBA, I recorded this macro and tested it thoroughly, and it worked fine. ...
    (microsoft.public.excel.worksheet.functions)
  • PLEASE HELP!!!!
    ... I have 5 machines that recored everything they do and save it in two ... The macro i made opens five of the datalogs (5 txt ... more files into the folder. ...
    (microsoft.public.excel.programming)
Loading