Cannot access Shapes(1).OLEFormat after convert to PowerPoint 2007

D

David Le

Hi All,

I've got a Graph and Excel Sheet table (with custom tags) created in PPT
presenation in Powerpoint 2003. After convert and saved the presentation to
Powerpoint 2007 format, I cannot in VBA accessing the
Shapes(1).OLEFormat.Object for Graph. I need to access the
Shapes(1).OLEFormat object to be able to change the graph title and data.

For Each pShape In Shapes
If Left(pShape.OLEFormat.ProgID, 13) = "MSGraph.Chart" Then
'Get chart object
Set pChart = pShape.OLEFormat.Object.Application.Chart

'Update chart title
pChart.HasTitle = True
pChart.ChartTitle.Text = "Hello!"
End If
Next

Also, the TAGS object count is 0 (zero) for Excel.Sheet table shape after
the conversion to Powerpoint 2007.

For Each pShape In Shapes
If Left(pShape.OLEFormat.ProgID, 11) = "Excel.Sheet" Then
If pShape.Tags.Count > 0 Then
'Do something...
Else
'No tags
End If
End If
Next

Is there any way that I can workaround the problem and any suggestions or
Microsoft need to fix the conversion in PowerPoint 2007?

I think this is conversion problem when converting earlier Powerpoint
presentation to Powerpoint 2007.

Regards,
David
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top