MS PowerPoint 2

[Andyleates]

Does anyone know if it is possible to auto update a date / time field on slide change and not just every time the slide show is restarted?

Regards

Andy

Andy Leates MCSE CCNA MCP+I

 

[fumei]

Not sure what you mean by "date / time field on slide change". You can make a date/time field update automatically by checking the update automatically checkbox when you insert the field.

I am probably missing something. Slide change?



Gerry

 

[Andyleates]

Thanks for the reply. I have "update automatically" checked when inserting a date time field. I only have two slides, one says welcome to... the other the date and time, looping round over and over. However the time never updates. Only when you stop the presentation and restart it do you get updated.

Andy

Andy Leates MCSE CCNA MCP+I

 

[Harlequin007]

This sound like a "Rolling" presentation you give at company receptions.

I use some code in Excel that's similar but not "LIVE". If I am right, you are looking for LIVE code that changes "realtime".

----------------------------
Cogito Ergo Sum

http://www.discworks.co.uk

----------------------------

 

[Andyleates]

That's exactly what I am looking for.

Andy Leates MCSE CCNA MCP+I

 

[Harlequin007]

Give me some time to work on this . . .

----------------------------
Cogito Ergo Sum

http://www.discworks.co.uk

----------------------------

 

[Harlequin007]

Andy

I use the following formula in Excel:

=TEXT(NOW(),"mmmm dd, yyyy")&" "&TEXT(NOW(),"[$-409]h:mm AM/PM;@")

Insert the excel cell that contains that formula into your presentation, it should be live but only refresh when the slide is shown.

Let the presentation cycle for a minute or so and tell me if it does what you need.

----------------------------
Cogito Ergo Sum

http://www.discworks.co.uk

----------------------------

 

[Harlequin007]

I suspect what you REALLY need Andy is a "Clock".

I'll dig around.

----------------------------
Cogito Ergo Sum

http://www.discworks.co.uk

----------------------------

 

[Harlequin007]

Andy

I used VBA in excel and pasted this into PowerPoint and it cycled to a new time each time the slide was shown.

I'd use that if you want "REAL" time.

----------------------------
Cogito Ergo Sum

http://www.discworks.co.uk

----------------------------

 

[barnhouse]

I have a similar situation going on here. I have a powerpoint slide show that is about 50 pages or so in length.

I have downloaded and installed AutoDateTime off of the Internet (

http://officeone.mvps.org/autodatetime/autodatetime.html

), and that causes my show to freeze every 15 or 30 hours. I want to have VBA code or somthing else that will not cause the show to crash, but I cannot find a good solution.

Any help anyone could provide would be greatly appriciated. I tried the excel method above and apparently I am not doing something correct because it does not update.

 

[Harlequin007]

Guys

I came accross some Java code that does exactly what you need. it actually ticks over each second while being displayed. It's primary use is HTML but I doubt it would be difficult to incorporate this into a PP slideshow.

<DIV id=Clock align=left style="font-family: Verdana; font-size: 12; Font-weight: bold; color:#008080"> </DIV>

<SCRIPT LANGUAGE="JavaScript">
function tick() {
var hours, minutes, seconds, ap;
var intHours, intMinutes, intSeconds;
var today;

today = new Date();

intHours = today.getHours();
intMinutes = today.getMinutes();
intSeconds = today.getSeconds();

if (intHours == 0) {
hours = "12:";
ap = "Midnight";
} else if (intHours < 12) {
hours = intHours+":";
ap = "AM";
} else if (intHours == 12) {
hours = "12:";
ap = "Noon";
} else {
intHours = intHours - 12
hours = intHours + ":";
ap = "PM";
}

if (intMinutes < 10) {
minutes = "0"+intMinutes+":";
} else {
minutes = intMinutes+":";
}

if (intSeconds < 10) {
seconds = "0"+intSeconds+" ";
} else {
seconds = intSeconds+" ";
}

timeString = hours+minutes+seconds+ap;

Clock.innerHTML = timeString;

window.setTimeout("tick();", 100);
}

window.onload = tick;

Hope that helpd guys.



----------------------------
Cogito Ergo Sum

http://www.discworks.co.uk

----------------------------

 

[barnhouse]

I cannot get this code to work... I added a </SCRIPT> command at the bottom of the code, however all I get is a blank page in IE...

 

[barnhouse]

I was finally able to get it to display and update the time and display, however I have not been able to get it to display in powerpoint... I get the small yellow box indicating a JavaScript insert, however it does not activate...

 

[TAJSimmons]

Andyleates,

This sounds like a job for the AutoDateTime Add-in!
from

http://officeone.mvps.org/autodatetime/autodatetime.html

Cheers
TAJ Simmons
microsoft powerpoint mvp

awesome - powerpoint graphics

http://www.powerpoint-graphics.com

 

[barnhouse]

The problem with the AutoDateTime addin is that it is not truly compatible with PowerPoint. It can cause random lockups of the presentation, which cause it not to advance to the next slide. It will, however, continue to update the time and date. I have been trying to migrate to a different solution. I feel JavaScript would be a better application for my presentation.

 

[barnhouse]

*bump*

 

[TAJSimmons]

barnhouse,

I think you'll find it's powerpoint that is the problem with crashing and locking up after 15-30 hours, and not the add-in. It's a known problem with powerpoint locking up after running for a long time.
See
PowerPoint locks up when running a presentation non-stop

http://www.rdpslides.com/pptfaq/FAQ00221.htm

Also PowerPoint cannot have JavaScript embedded within a slideshow.

Cheers
TAJ Simmons
microsoft powerpoint mvp

http://www.powerpointbackgrounds.com