Change Source for Excel Links to PowerPoint

  • Referencing an old thread: but hoping to improve on the code.

    I used the code and it works great as long as only one excel source file is linked to the Presentation. Was hoping code could be modified to do the following (assuming there are more than one linked files):

    1. Scan the PPT file and list all external excel source files within the document.
    2. Allow the user to pick one of the existing source files.
    3. Apply the below code to change the selected old source file with the the newly selected source file.