If false do nothing

    Hi Carim,


    Have another issue now. I needed to embed this excel to a ppt and be able to edit it as ' chart in Microsoft powerpoint' object. It seems the ppt can't process/ figure out the code and does nothing when I open it from the ppt and click on the copy quarter data,

    Hello again,


    Not sure to fully understand your latest remark ...


    If you need to automate Excel from PowerPoint ... it is a totally different issue !!!


    For your info, see following:


    https://www.rdpslides.com/pptf…rom_Excel-_And_so_on-.htm


    Hope this will help

    :)

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

    Should you spot some other bug ... do not hesitate to let me know ;)

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

    Love 1

    Many Many Thanks.


    Would you be able to suggest beginners lessons I can take on Macros. I consider myself good with formulas but I didnt want to even attempt to edit the macro for the risk of breaking it.

    You are very welcome :)


    Regarding your desire to learn macros ... there is a wealth of resources available ...


    1. If you are looking for a web site : https://www.excel-easy.com/vba.html

    or a more interactive concept : https://www.automateexcel.com/learn-vba-tutorial/#vba-basics


    2. If you are looking for a YouTube video :

    External Content www.youtube.com
    Content embedded from external sources will not be displayed without your consent.
    Through the activation of external content, you agree that personal data may be transferred to third party platforms. We have provided more information on this in our privacy policy.


    3. If you are looking for the BEST book : Author: John Walkenbach Excel VBA Programming for dummies - A TRUE LEGEND !!!


    Hope this will help

    :)

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

    Love 1

    Thank you Carem.


    Dare I take this one step forward. I linked all the graphs and tables from this excel to be presented in a ServiceReport.ppt


    I would need to create several copies of this the ppt and excel duo for each client / manager. You know the problem of broken link!


    FOund this link which I havent tried yet, but looks that it would work.


    It says: For the code above it will be necessary to set the values for the sourceFileName, oldFilePath and newFilePath variables.


    Question to you is: Is it possible to create a textbox / button on the excel sheet where a manager can put all three variables and it will change the variables in the code.


    Even if it means it can be done from another excel / ppt / anything else, I would prefer to include that in the report set than to ask a whole bunch of them to edit the code.


    Many thanks

    P

    Hello again,


    As soon as I have a moment ... will look into your latest concern ...;)

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

    Love 1

    Hello,


    Understand you want to adapt the macro Sub EditPowerPointLinks() to your specific situation ...


    Indeed, there are three variables, and you do need to to set the values for the sourceFileName, oldFilePath and newFilePath variables...


    Have you already included the macro in your Service Report file ... and tested it with one set of a given " manager ' s data " ... ?


    Indeed, before expanding the feature to a large number n of different managers, you do need to be 100% sure everything is fully operational for one manager ...


    Hope this will help

    :)

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

    Hello Pooja,


    For the sake of getting started ... you should test your own file within your own specific environment ...


    see attached test file ...


    Hope this will help clarify the issue

    :)

    Sadly ... cannot perform the test for you ... since all the three variables are specific to your own environment ...


    To get a good indication of what needs to be done ... you do get an idea from the three instructions



    for example the whole text "C:\File Path \Of Source File\File Name.pptx" needs to be replaced by your specific full file name ... ;)

    Hope this will help clarify

    :)

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

    Love 1

    I am calling these three variables in the code:

    PowerPoint \\local\Shared\Customer Service\Service Report Template\excel link test\Service Report v1.2.pptx
    Old Excel Link \\local\Shared\Customer Service\Service Report Template\Service report backend Copy 1.xlsm
    New Excel Link \\local\Shared\Customer Service\Service Report Template\excel link test\Service report backend excel test.xlsm

    I am confused at how it converted all the worksheet links in the ppt, but not changed any of the chart links. (previous screenshot) some tweaks needed to edit the chart links ?

    If I understanding correctly the first step related to adjusting the three variables is now operational ...


    BUT you are left the last issue of adjusting the chart links ...


    Is that right ?

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

    OK ... First step


    Do you now within your code the following three instructions

    Code
    'The file name and path of the file to update
sourceFileName = Range("B1").Value

'The old file path as a string (the text to be replaced)
oldFilePath = Range("B2").Value

'The new file path as a string (the text to replace with)
newFilePath = Range("B3").Value

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

    yes the variables are called successfully


    they are changing the old link to the new link on the ppt for all the worksheets embeded from excel to the ppt


    But they are failing to change the old link to the new link on the ppt for all the CHARTS embeded from excel to the ppt

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login