PDA

View Full Version : Applescript to update multiple Linked Files Powerpoint-Excel




cdolan92
Dec 9, 2011, 02:10 PM
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



cdolan92
Dec 9, 2011, 02:54 PM
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


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

::

cdolan92
Dec 11, 2011, 08:19 PM
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

::

Does anyone have an idea? Would be much appreciated!