If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
PPT2007 Charts and VBA
I remember coming across a problem with charts in a VBA program I have
written when the customer upgraded to 2007. Looking into the matter, I came across the listing at PPTTools which mentions that 2007 charts are not exposed to VBA: http://www.pptfaq.com/FAQ00889.htm At the time, I believe a coworker had checked the 'Convert' when editing a chart, and it no longer worked with the program I had written. Now the same charts seem to be working again when they are converted, or even created as brand new charts in 2007 with the same code. Is this something that Microsoft fixed at some point? If so, does anyone know what version was the fix applied, and can I test for the service pack version in VBA to make sure my client has the proper upgrade when running the code? |
#2
|
|||
|
|||
PPT2007 Charts and VBA
I believe I found my answer to the charts: http://support.microsoft.com/kb/948683
To resolve this issue, install 2007 Office Suite Service Pack 2. After you install 2007 Office Suite Service Pack 2, you can use Microsoft Visual Basic for Application (VBA) to modify a chart that you have inserted in PowerPoint 2007 or Word 2007. Is there a way to determine with VBA if this service pack has been installed? The only property I can see that I think might be it is the application.build property. On my machine, I get '6425' for this value. |
#3
|
|||
|
|||
PPT2007 Charts and VBA
If it's any help I get 6514 on PP2007 SP2 and 4535 on PP2010 beta
Mark wrote: I believe I found my answer to the charts: http://support.microsoft.com/kb/948683 To resolve this issue, install 2007 Office Suite Service Pack 2. After you install 2007 Office Suite Service Pack 2, you can use Microsoft Visual Basic for Application (VBA) to modify a chart that you have inserted in PowerPoint 2007 or Word 2007. Is there a way to determine with VBA if this service pack has been installed? The only property I can see that I think might be it is the application.build property. On my machine, I get '6425' for this value. |
#4
|
|||
|
|||
PPT2007 Charts and VBA
On Mar 4, 9:54*am, James jahbur-at-yahoo.co.uk wrote:
If it's any help I get 6514 on PP2007 SP2 and 4535 on PP2010 beta Mark wrote: I believe I found my answer to the charts:http://support.microsoft.com/kb/948683 To resolve this issue, install 2007 Office Suite Service Pack 2. After you install 2007 Office Suite Service Pack 2, you can use Microsoft Visual Basic for Application (VBA) to modify a chart that you have inserted in PowerPoint 2007 or Word 2007. Is there a way to determine with VBA if this service pack has been installed? The only property I can see that I think might be it is the application.build property. On my machine, I get '6425' for this value.- Hide quoted text - - Show quoted text - Thanks for the response. Don't know how helpful it is to me until I can determine if a specific number or number range specifies SPX. I checked several computers in the office, and I'm getting so far 2 different numbers; yours is a 3rd value. In the PowerPoint options I checked and got 12.0.6425.1000 on 2 machines, and 12.0.6504.5000 on 2 other machines. The first set of 4 digits after the version (12.0) correlates with the 'Build' number for the application. Don't know what the last 4 digits means. I'll have to keep looking online hoping I can find an answer, or hope that someone knowledgeable responds here. Thanks again |
Thread Tools | |
Display Modes | |
|
|