Extracting date/time text from footer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

josh.projects@gmail.com - 26 Nov 2007 07:50 GMT

Hello all,

How can I extract the actual text displayed in a "date and time"
footer?

If it's set to "fixed", I can get the text using
Slide.HeadersFooters.DateAndTime.Text, but if it's set to "update
automatically", the text doesn't seem to be stored anywhere.

Using Powerpoint 2003 by the way.

Thanks in advance

Reply to this Message

Michael Koerner - 26 Nov 2007 12:37 GMT

I believe that update automatically uses the system time and is not stored

Signature

Michael Koerner
MS MVP - PowerPoint

Reply to this Message

John Wilson - 26 Nov 2007 13:09 GMT

Hi Josh

As Michael said the time in the footer is updated to show the system time
<NOW> everytime the slideshow runs. If you try to read <NOW> (which is easy)
the time you read will not be the same as the time the show started but the
current time!

Try this: Add a textbox to slide 1 and use insert > date and time (auto
update) use the same date format. This will also show the time the show
started. You can drag it off slide so that it doesn't show.SlideMaster This
text can be read with some thing like:

ActivePresentation.Slides(1).Shapes(4).textFrame.TextRange

Signature

Amazing PPT Hints, Tips and Tutorials

http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk
email john AT technologytrish.co.uk

> Hello all,
>
[quoted text clipped - 8 lines]
>
> Thanks in advance

Reply to this Message

josh.projects@gmail.com - 27 Nov 2007 03:35 GMT

Thanks very much Michael and John! The suggested workaround solves my
problem :)

A follow-up question, just for future reference... in the Header /
Footer dialog, there are "Language" and "Calendar type" settings. Can
these settings be accessed using VB?

Thanks again.

On Nov 26, 9:09 pm, John Wilson <john AT technologytrish.co DOT uk>
wrote:

> Hi Josh
>
[quoted text clipped - 29 lines]
>
> > Thanks in advance

Reply to this Message