If false do nothing

  • Good to hear there is good progress :)


    Regarding the chart links ... it could be related to the way you have picked to link your Excel charts to your PowerPoint presentation ...


    Have you noticed within the code that the type msoLinkedChart does not exist ... and has to be replaced by msoLinkedGraphic ...


    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • To be on the safe side ... you could look for the solution you have picked among the 3 possibilities :

    1. Picture

    2. OLEObject

    3. Graphic Object ( the most robust one)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • I know you wont be able to compile the code i have sent, but could you edit it so I understand how to call Graphic Object ?


    I have added both, still can't get it to edit the link to the charts. The way I added the chart to ppt is by copying and paste special with 'source formatting and link data'



  • Below is the proposed modification to be tested :


    You will notice on Line 7 that the type msoLinkedChart has been replaced by msoLinkedGraphic


    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • The module where the macro is located does not have any impact on the macro 's effectiveness...


    However, a crucial point is the following :


    Alt F11 to get to VBE

    From the main menu ... select Tools > References

    Go down the long list of librairies to select Microsoft Powerpoint xx.x Object Library


    Indeed, this library contains all the code required to allow Excel to control Powepoint


    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • Hi Carim


    Please see the files.


    Charts are not updating but worksheets are.


    I had already selected the powerpoint from the library for early binding.


    I am also beginning to think the code can be matured to not need the old excel location - if you like to try your hands on !


    I am late in sending this to you but would be ever so grateful if you could have an early look at it.


    I tried adding pptShape.Type = msoCharts but linking in the next code line failed


    'Find out if the shape is a linked object or a linked picture

    If pptShape.Type = msoLinkedPicture Or pptShape.Type = msoLinkedOLEObject Or pptShape.Type = msoLinkedChart Or pptShape.Type = msoLinkedDesign Or pptShape.Type = msoCharts Then


    'Use Replace to change the oldFilePath to the newFilePath

    pptShape.LinkFormat.SourceFullName = Replace(LCase(pptShape.LinkFormat.SourceFullName), LCase(oldFilePath), newFilePath)

  • As soon as I have a moment ... will take a look ...;)


    But ... you will admit with me ... when it comes to computing, say a macro ... it either works or it doesn't ... rarely something in-between

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)