OLEFormat.object access is very slow

  • Thread starter Thread starter Matt Tessar
  • Start date Start date
M

Matt Tessar

Hello,

I have an application that adds charts into powerpoint
using the AddOLEObject function. When I attempt to assign
the recently added object to a variable of type
Excel.Chart from the shape.OLEFormat.Object property , it
takes quite a while. This assignment/cast seems to take
about 1 second to complete. Does anyone know why this is
so slow? Is there a different way to access the pointer
to the chart than using the OLEFormat.object property? Is
there a way to speed this up?

Thanks
Matt
 
Hi Matt,

Thank you for posting questions in the newsgroup. I will take a look at
this issue and update you when I get any result.

Thanks,

Regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

--------------------
 
Matt -

Is it a chart that you will need to update? I've found OLEFormat to be
(a) slow, and (b) incomprehensible. Rather than using this approach
with charts embedded in other applications, I've found it easier to redo
the chart in Excel, then replace the old one in the other app with the
new one. This is done with shapes, which is easier than OLE stuff.

- Jon
 
Peter -

This meaningless response is worse than no response at all. Someone who
knows the answer or a workaround may skip the question, seeing that it
was already answered. I suspect you may have to make X posts per month,
but you just wrote Matt a speeding ticket he didn't deserve.

- Jon
 
Hi Matt,

I can not reproduce the problem. You may try to make a test with a simple
excel chart in a simple PowerPoint presentation.
Can you simplify the code to demostrate the problem and post it here for me
to reproduce the problem?

I look forward to hearing from you.
Regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------
X-Tomcat-ID: 322802556
References: <[email protected]>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
From: (e-mail address removed) (Peter Huang [MSFT])
Organization: Microsoft
Date: Fri, 29 Aug 2003 13:38:43 GMT
Subject: RE: OLEFormat.object access is very slow
X-Tomcat-NG: microsoft.public.excel.programming
Message-ID: <[email protected]>
Newsgroups: microsoft.public.excel.programming
Lines: 43
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.programming:411196
NNTP-Posting-Host: TOMCATIMPORT1 10.201.218.122

Hi Matt,

Thank you for posting questions in the newsgroup. I will take a look at
this issue and update you when I get any result.

Thanks,

Regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

--------------------
Content-Class: urn:content-classes:message
From: "Matt Tessar" <[email protected]>
Sender: "Matt Tessar" <[email protected]>
Subject: OLEFormat.object access is very slow
Date: Thu, 28 Aug 2003 17:04:27 -0700
Lines: 15
Message-ID: <[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Thread-Index: AcNtwRzbaPksUI8GQGCF7QoldiMTKA==
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Newsgroups: microsoft.public.excel.programming
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.programming:411073
NNTP-Posting-Host: TK2MSFTNGXA13 10.40.1.165
X-Tomcat-NG: microsoft.public.excel.programming

Hello,

I have an application that adds charts into powerpoint
using the AddOLEObject function. When I attempt to assign
the recently added object to a variable of type
Excel.Chart from the shape.OLEFormat.Object property , it
takes quite a while. This assignment/cast seems to take
about 1 second to complete. Does anyone know why this is
so slow? Is there a different way to access the pointer
to the chart than using the OLEFormat.object property? Is
there a way to speed this up?

Thanks
Matt
Click to expand...
Click to expand...
 
Back
Top