#1
|
|||
|
|||
VBA Update Excel info in running Presentation
I have two slides - each with a linked Excel Object. I open the Excel file - then PPt and start Kiosk Presentation.
If the excel file updates - the PPt was not updating. I found a VBA how to: in Class Module "clsEvents" I have: Code:
Public WithEvents PPTEvent As Application Sub PPTEvent_SlideShowNextSlide(ByVal Wn As SlideShowWindow) Dim objSld As Slide, shp As Shape Set objSld = Wn.Presentation.Slides(Wn.View.CurrentShowPosition) For Each shp In objSld.Shapes If shp.Type = msoLinkedOLEObject Then shp.LinkFormat.Update End If Next shp End Sub Code:
Option Explicit Dim app As clsEvents Sub SetUpEvents() Set app = New clsEvents Set app.PPTEvent = Application End Sub |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Running Excel from a webpage | jimbassett | Excel | 0 | 04-22-2014 02:11 PM |
How do I auto-update the TODAY excel function within PowerPoint show presentation? | Powerpoint100 | PowerPoint | 0 | 02-12-2013 01:45 PM |
How to scroll down the slide while presentation running? | aditya_bokade | PowerPoint | 6 | 08-12-2012 12:09 AM |
Table update in running presentation | rumdrum | PowerPoint | 0 | 02-10-2011 01:28 PM |
Running total in Excel chart | jen152638 | Excel | 0 | 06-14-2010 05:38 AM |