Applescript to update multiple Linked Files Powerpoint-Excel

Discussion in 'Mac Programming' started by cdolan92, Dec 9, 2011.

  1. macrumors newbie

    Joined:
    Nov 18, 2009
    #1
    Hello all,

    I have a powerpoint presentation with many linked fields that are sourced from an excel workbook. To update these in Microsoft Office 2004 and 2008, I have to manually click on each, update it, etc. It simply takes forever to complete when there are 50 fields... On top of that, this has be done multiple times per week.

    Is there an AppleScript that exists to do this automatically? I have searched for a long time and have yet to find one.

    Ideally this would work with both Office 2004 and Office 2008 for mac. Any help would be appreciated, as I am pretty unfamiliar with coding AppleScript. Again, I need a script that will update parts of my powerpoint presentation from data in my excel workbook.

    Thanks,
    Charlie
     
  2. thread starter macrumors newbie

    Joined:
    Nov 18, 2009
    #2

    Update:

    I played with the ScriptEditor and built this. My Applescript knowledge is obviously very limited :)

    Where did I go wrong:

    tell "Microsoft Powerpoint"
    update links active presentation
    end tell

    ::
     
  3. thread starter macrumors newbie

    Joined:
    Nov 18, 2009
    #3
    Does anyone have an idea? Would be much appreciated!
     

Share This Page