Thanks in advance, experts!!!!!!
I have a PowerPoint presentation that has links to Excel charts that
need to be updated each time the Excel file is changed. I have
everything working fine (I can update, save, and close the Excel file,
open PP, and it prompts me to Update Links - I click yes, and it
updates fine)
What I want to be able to do is when I click a button on Excel, have
it open the PP, close/save Excel, and update the links to charts in
Excel. I have the code to open PP itself then close/save Excel, but
when I open the PP file using this code, it never prompts to update
the links (and it doesn't update). Here's the code I have so far:
Dim objPPT As Object
Set objPPT = CreateObject("PowerPoint.Application")
objPPT.Visible = True
objPPT.Presentations.Open "\\ServerName\FileName.pptx"
ActiveWorkbook.Close True
This opens PP, then saves/closes Excel - but I then have to navigate
within the PP to update the links. The problem is, the Excel file has
to be closed before the PP will update the links. I'm trying to make
this all simple for all the users of it (open an Excel file, make a
change, click a button - and it will save/close the Excel file, open a
pre-designed PP file and update all links with data they just changed)
- seems simple, but I can't figure out this last step! Even if they
got the prompt they do when they open the file directly, that would be
acceptable, but I can't figure out why when opening the PP file from
this macro, it doesn't prompt to update the links within PP.
Thanks for any help!!!!!!!!!!
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
