+ Reply to Thread
Results 1 to 4 of 4

Open/Update Powerpoint, but doing each one twice?

  1. #1
    Forum Contributor
    Join Date
    05-23-2007
    Posts
    126

    Open/Update Powerpoint, but doing each one twice?

    One part of a weekly report macro updates four separate powerpoint slides' links. As each powerpoint is opened, I'm prompted in excel to open the linked file. That's fine, but it appears to be asking me twice for each powerpoint. Pasting the code below, and I can't see what might be causing the duplication. There is only one charted linked in each powerpoint file. Any help is greatly appreciated.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,437

    Re: Open/Update Powerpoint, but doing each one twice?

    Try this revision.
    No need for the SaveAs if the filename is the same.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    05-23-2007
    Posts
    126

    Re: Open/Update Powerpoint, but doing each one twice?

    Quote Originally Posted by Andy Pope View Post
    Try this revision.
    Will do! I run it on Mondays so will update then. Many thanks!

  4. #4
    Forum Contributor
    Join Date
    05-23-2007
    Posts
    126

    Re: Open/Update Powerpoint, but doing each one twice?

    And Andy... just noticing what you did with the filename array... beautiful! (or as you Brits might say, lovely!)

    Cheers!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Update content of PowerPoint using VBA
    By ell_ in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-15-2017, 10:41 PM
  2. Replies: 0
    Last Post: 08-23-2016, 09:43 AM
  3. Replies: 1
    Last Post: 06-09-2016, 12:05 PM
  4. Need to change VBA code from creating new PowerPoint to open an existing PowerPoint
    By bmchenry3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 12:14 AM
  5. Update embedded excel containing sql in powerpoint
    By DeNam in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2013, 08:23 AM
  6. Replies: 13
    Last Post: 01-11-2013, 04:46 PM
  7. VBA to update PowerPoint slides.
    By bapatterson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2010, 01:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1