Auto Moving Time Indicating Line

[Rob]

I have a normal line that is used to indicate the approximate time of the day
within a slide that has a time-line. Currently I have to move that line
manually multiple times a day every day. I'm wondering if it is possible to
have a macro that does this automatically and constantly?

Thanks In Advance,
Rob

 

[Bill Dilworth]

Hi Rob,

Yes, a macro can be written to show what percent of the day is completed in
a line style format.
Yes, it can run automatically when each slide is opened.

What do you know already about VBA or COM addin/macros?
Will you be in Atlanta at PowerPoint Live?

Bill Dilworth

 

[Rob]

My Apologies for the delay in responding but I was away for work issues.

I'm what you would consider a haphazard novice with basic understanding in
VB. I'll stumble on the right path if it's very straight forward but when it
comes to the logic and unique codes I fail poorly.


To answer Steve's question... what I would do is assume the distance the
start of the page to the First indicating line and count how many inches it
is in distance to the last line;
1st Line is at 0.75" and the last is at 9.5"
The difference is 8.75" inches
I'm using it for a 3.5 day span or 7 periods of 12 hours, so the math would
be that each twelve hour period is equal to 1.25 inches.
So the clock would tick off 12 hours within a 1.25 space which would roughly
be .1042 inches for every hour.

So if I set the beginning time to be 12 AM on the 22nd and the end time at
12 PM on the 25th then I would think that the macro would evaluate what the
system time is and then auto calc where the position of the line should be.

I just wish I knew how to make a macro do that in PowerPoint. I can work
out the dynamics to almost any programing needs... I just can't for the life
of me figure out how to "Actually" make the code work.

Thanks Again and Sorry for the Tardiness in replying.

Cheers!
Rob

 

[Rob]

Ahhh... well I was wondering if PowerPoint has a Volatile VB call that works
as a keep alive or something. Like what you can do with an Excel Function
"Application.volatile" or A Clocking monitor.

I was thinking something in the area of putting a countdown for when the
presentation is opened. My thought is that when the file is opened the macro
looks at the system clock and determines the current time. Then it'll start
an internal countdown to the next hour interval and move the line and reset
the counting again.

Or am I thinking pie-in-the-sky?

Cheers,
Rob