Update powerpoint links from Excel

Good Morning All,

I've created a reporting masterpiece that's collecting data from various data extracts and manipulating them to create numerous reports - turned a 6 hour job into a 5 minute one. Now my boss wants a presentation with some of the data each morning. I've created the powerpoint presentation and linked it to the excel data sources. I've set it up so that the soruce files and the powerpoint presentation will both be open to speed up the update - I just can't seem to figure out how to run script within excel that will instruct powerpoint to update the links.

i've got the code to close excel and powerpoint and mail the presentation for me - just missing that vital piece?

any geniuses out there have a solution?

Forgive me being a complete moron this morning, here's the code I'm using to open the source file and the presentation as well as to close both again. I've tried a variety of ideas to force the update of the presentation but so far nothing

Please Login or Register  to view this content.

IDEAS ATTEMPTED

Please Login or Register  to view this content.

Solved this one: I had to turn update links on and then use a different code to break the links and save the file as a different presentation. Here's what I used if anyone else needs it.

Please Login or Register  to view this content.