I have a .PPT (2003) file that I want to convert to .PPTX 2007 format using VBA in Excel. How do I do this?
I have a working code for opening the ppt file, navigating through slides & shapes. There is one particular chart that I want to be able to edit (or read data) using Excel VBA and I am unable to do so because the file is in 2003 format and chart is an Embedded OLE Object. My plan is to convert the presentation to 2007 format and then read it easily. This action is manually achieved using PPT->File->Info->Convert but I want to do this using VBA.
I have tried saving the presentation in .pptx format but that doesn't convert elements. Please help. Thanks!
I have a working code for opening the ppt file, navigating through slides & shapes. There is one particular chart that I want to be able to edit (or read data) using Excel VBA and I am unable to do so because the file is in 2003 format and chart is an Embedded OLE Object. My plan is to convert the presentation to 2007 format and then read it easily. This action is manually achieved using PPT->File->Info->Convert but I want to do this using VBA.
I have tried saving the presentation in .pptx format but that doesn't convert elements. Please help. Thanks!
