+ Reply to Thread
Results 1 to 2 of 2

Update automatic links to power point upon closing of excel file

  1. #1
    Forum Contributor
    Join Date
    12-11-2010
    Location
    Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    118

    Update automatic links to power point upon closing of excel file

    Hi,
    I have noticed that even though the power point file that contains all the data/charts pulled from excel files, it will not update it's display (on a monitor), until the actual power point is opened.
    Is it possible to open the power point for a few seconds, than save it and shut it down again (through the excel file that is being updated - maybe upon closing of the excel file)?
    I had an old code I used to open an excel file, retrieve data......
    wondering id this code works with a pptx?
    - - The application ran in the old file (Application.Run) was to copy, paste and manipulate sets of data, which is unnecessary for this file (power point pptx)

    Any help and/or insight is greatly appreciated.
    Thank you
    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    01-03-2016
    Location
    Conwy, Wales
    MS-Off Ver
    2016
    Posts
    974

    Re: Update automatic links to power point upon closing of excel file

    Code below opens, saves and closes a powerpoint presentation.
    Amend file path and file name
    Put this code into the workbook module and it will run every time the workbook closes

    Please Login or Register  to view this content.
    Last edited by Kevin#; 03-15-2016 at 04:15 AM.

+ 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. Can't update/refresh Embedded Excel file within Power Point
    By Mt1013 in forum PowerPoint Formatting & General
    Replies: 1
    Last Post: 06-17-2015, 12:06 AM
  2. Macro to update excel data table in power point
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-09-2014, 08:13 AM
  3. Replies: 0
    Last Post: 06-17-2014, 12:21 PM
  4. Copy graph from Excel to Power Point & update it automatically
    By zuppi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-06-2012, 10:19 AM
  5. Create/Update Excel Objects in Power Point
    By cl in forum Excel General
    Replies: 0
    Last Post: 06-27-2005, 06:05 AM
  6. [SOLVED] Create/Update Excel Objects in Power Point
    By cl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2005, 06:05 AM

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