Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Excel 2003 - very slow access to hard drive | Excel Discussion (Misc queries) | |||
How to speed up slow network access in office 2003 | Excel Discussion (Misc queries) | |||
How do I access to property of chart object ? | Charts and Charting in Excel | |||
Excel Hyperlink to specific Access object | Excel Discussion (Misc queries) | |||
Access privilege problem with Excel object | Setting up and Configuration of Excel |