Update OLE links, linking to Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yakof - 19 Oct 2006 09:23 GMT

Hi, I need to update a ppt file full of bad OLE links and I can't find a
macro that works for these links. The OLE objects are microsoft graphs
pointing to an excel datasheet. Thanks in advance

Reply to this Message

John Wilson - 19 Oct 2006 09:34 GMT

Would this help?
http://www.pptfaq.com/FAQ00759.htm

Signature

Did that answer the question / help?
_____________________________
John Wilson
Microsoft Certified Office Specialist
http://www.technologytrish.co.uk/ppttipshome.html

> Hi, I need to update a ppt file full of bad OLE links and I can't find a
> macro that works for these links. The OLE objects are microsoft graphs
> pointing to an excel datasheet. Thanks in advance

Reply to this Message

Yakof - 19 Oct 2006 09:40 GMT

Thanks John, but I already tried it, It displays the msg Done but the bad
links remain the same.

> Would this help?
> http://www.pptfaq.com/FAQ00759.htm
>
> > Hi, I need to update a ppt file full of bad OLE links and I can't find a
> > macro that works for these links. The OLE objects are microsoft graphs
> > pointing to an excel datasheet. Thanks in advance

Reply to this Message

John Wilson - 19 Oct 2006 09:49 GMT

You did save the file , reopen and allow links to update? (soory but I dont
know how competent you are!)

You could try stepping through the code with f8 to make sure its going round
the loop etc

Signature

Did that answer the question / help?
_____________________________
John Wilson
Microsoft Certified Office Specialist
http://www.technologytrish.co.uk/ppttipshome.html

> Thanks John, but I already tried it, It displays the msg Done but the bad
> links remain the same.
[quoted text clipped - 5 lines]
> > > macro that works for these links. The OLE objects are microsoft graphs
> > > pointing to an excel datasheet. Thanks in advance

Reply to this Message

Yakof - 19 Oct 2006 10:03 GMT

Yes John, I saved the file and re-opened but to no avail. When pressing f8,
it doesn't give any errors in VB Editor

> You did save the file , reopen and allow links to update? (soory but I dont
> know how competent you are!)
[quoted text clipped - 11 lines]
> > > > macro that works for these links. The OLE objects are microsoft graphs
> > > > pointing to an excel datasheet. Thanks in advance

Reply to this Message

Yakof - 19 Oct 2006 10:45 GMT

Any other ideas fellas?

> Yes John, I saved the file and re-opened but to no avail. When pressing f8,
> it doesn't give any errors in VB Editor
[quoted text clipped - 14 lines]
> > > > > macro that works for these links. The OLE objects are microsoft graphs
> > > > > pointing to an excel datasheet. Thanks in advance

Reply to this Message

Shyam Pillai - 19 Oct 2006 14:38 GMT

Are these Excel charts or the PowerPoint charts? If these are PowerPoint
graphs which have an Excel source then you are out lot luck, the object
model does not allow access to the source. You would have to do it manually.

Signature

Regards,
Shyam Pillai

Image Importer Wizard
http://skp.mvps.org/iiw.htm

> Hi, I need to update a ppt file full of bad OLE links and I can't find a
> macro that works for these links. The OLE objects are microsoft graphs
> pointing to an excel datasheet. Thanks in advance

Reply to this Message

Steve Rindsberg - 19 Oct 2006 16:18 GMT

> Hi, I need to update a ppt file full of bad OLE links and I can't find a
> macro that works for these links. The OLE objects are microsoft graphs
> pointing to an excel datasheet. Thanks in advance

You'll have to do it manually, I'm afraid.

MSGraph will tell you that a graph has links but won't tell you where the links
point or let you change them via macro.

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Reply to this Message