#1
|
|||
|
|||
Delay calculation in PPT 2016
Hi guys,
after having spent almost 4 nights without getting hardly one single step forward, I finally had to admit that I would have to reach out to the pros. What I want to do is the following:
Let’s have an example.
Assuming that my presentation is scheduled to start at 09:00 (StartingTime = 09:00) and that it starts on time and the first two sections took as scheduled 15 minutes together, then the textboxes on slide 17 when starting section 3 should indicate: OverallTime = 15 minutes and Delay = 0 (Current time – (StartingTime + ChapterDuration[seciton1] + ChapterDuration[section2]) However, if the presentation actually started at 09:04 and the first section took say 3 minutes longer, than scheduled, the textbox Delay on slide 17 should display 7 minutes because the current time is now 09:22 and 09:22 – (09:00 + 5 minutes + 10 minutes) = 7 minutes. The three major problems I encounter are:
Thanks for your appreciated help. Michael |
#2
|
|||
|
|||
I know you understand exactly what you mean but it really isn't that clear
But Why do you think ActivX TextBoxes on the master do not work - they do. You could try this to run a mcro at slide xx Code:
Sub OnSlideShowPageChange(SW As SlideShowWindow) If SW.View.CurrentShowPosition = xx Then 'the slide in question Call themacro End If End Sub strText=ActivePresentation.Slides(3).Shapes("TextB ox1").OLEFormat.Object.Text If you measure the value od NOW at two points in the presentation you can use DateDiff to get the elapsed time Code:
Public d_then As Date Sub getEarlier() d_then = Now End Sub Sub getElapsed() MsgBox DateDiff("s", d_then, Now) & _ " seconds have elapsed.", vbInformation End Sub Last edited by JohnWilson; 05-11-2017 at 08:49 AM. |
#3
|
|||
|
|||
Thanks JohnWilson
Now, that I've spent 3 nights digging a little deeper into the object model of VBA and thanks to your help, it starts working... I'm completely new to VBA and it just feels so different to what I did till now. If you see a guy on CNN who caused a huge explosion coding in VBA, that's me... Thanks again and have a great day, Michael |
Tags |
calculation, vba |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sending e-mail with delay | paik1002 | Outlook | 1 | 02-29-2016 11:27 AM |
Auto run macro with delay | bremen22 | Excel Programming | 0 | 02-04-2016 06:53 AM |
Delay Analysis | ketanco | Project | 3 | 03-15-2013 01:06 PM |
Using the Delay fields | Foxfire | Mail Merge | 5 | 08-20-2011 02:40 AM |
Delay delivery | Registrar | Outlook | 1 | 07-01-2010 10:17 AM |