ID MSGraph.Chart in PPT 2K

  • Thread starter Thread starter Erin
  • Start date Start date
E

Erin

I have found a nifty bit of code on the internet for
taking a range in Excel and using it to update an MSGraph
object in PPT. However, the code was written for Office
97 and I am using 2000. I assume I need to change the
ProgID from 8 to 9, but there is still some glitch. It is
not identifying the MSGraph.Chart.9 object. I think the
issue is some change from Office 97 to 2000, but I don't
know what that would be.

Here is an excerpt:

If oPPTShape.Type = msoEmbeddedOLEObject Then
If oPPTShape.OLEFormat.ProgId = "MSGraph.Chart.9" Then

It is the 2nd line that doesn't work.

I am using Office 2K on Windows 2K Pro

Thank you for any help you may provide!

Erin
 
I have found a nifty bit of code on the internet for
taking a range in Excel and using it to update an MSGraph
object in PPT. However, the code was written for Office
97 and I am using 2000. I assume I need to change the
ProgID from 8 to 9, but there is still some glitch. It is
not identifying the MSGraph.Chart.9 object. I think the
issue is some change from Office 97 to 2000, but I don't
know what that would be.

Here is an excerpt:

If oPPTShape.Type = msoEmbeddedOLEObject Then
If oPPTShape.OLEFormat.ProgId = "MSGraph.Chart.9" Then

It is the 2nd line that doesn't work.
Click to expand...

What exactly doesn't work?
It might be that there's an MSGraph.Chart.8 object embedded in the shape.
Try

Msgbox oPPTShape.OLEFormat.ProgID
 
Back
Top