OLEFormat.object access is very slow
 

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

OLEFormat.object access is very slow
 

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"
Sender: "Matt Tessar"
Subject: OLEFormat.object access is very slow
Date: Thu, 28 Aug 2003 17:04:27 -0700
Lines: 15
Message-ID:
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

OLEFormat.object access is very slow
 

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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Matt Tessar wrote:
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

OLEFormat.object access is very slow
 

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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Peter Huang [MSFT] wrote:
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"
Sender: "Matt Tessar"
Subject: OLEFormat.object access is very slow
Date: Thu, 28 Aug 2003 17:04:27 -0700
Lines: 15
Message-ID:
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

OLEFormat.object access is very slow
 

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:
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
From: (Peter Huang [MSFT])
Organization: Microsoft
Date: Fri, 29 Aug 2003 13:38:43 GMT
Subject: OLEFormat.object access is very slow
X-Tomcat-NG: microsoft.public.excel.programming
Message-ID:
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"
Sender: "Matt Tessar"
Subject: OLEFormat.object access is very slow
Date: Thu, 28 Aug 2003 17:04:27 -0700
Lines: 15
Message-ID:
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