Excel and powerpoint

[billx]

Hello
Need Help
i have a excel spreadsheet that has tasks for every day
i would like to integrate it in powerpoint so it can be displayed automatically ... when the system date changes the slide changes with the task for that date
the tasks are the same only the times different for eash of the days throughout the year
this will be projected on a screen automatically
is this possible

 

[Mike_VBA]

Hello
Need Help
i have a excel spreadsheet that has tasks for every day
i would like to integrate it in powerpoint so it can be displayed automatically ... when the system date changes the slide changes with the task for that date
the tasks are the same only the times different for eash of the days throughout the year
this will be projected on a screen automatically
is this possible

Will you be have the entire tasks already in hand.. ? Or would you be adding them dynamically ?

 

[billx]

hello
Thanks for the reply
the tasks are the same
the time of task for each day is different
need to automate to display on powerpoint

Thanks

 

[Mike_VBA]

hello
Thanks for the reply
the tasks are the same
the time of task for each day is different
need to automate to display on powerpoint

Thanks

Powerpoint Version ? (2003 or 2007)?

 

[billx]

ADVERTISEMENT

2007 and 2003 available

 

[Mike_VBA]

2007 and 2003 available

Okay.. In 2007 if you want short sequences between slides (lets say 1-2.. minutes)... U can use rehearse timings under the Slideshow tab..

If you want longer sequences.. (ie., change slide after 6 hours 1 day etc) Use the Advance Slide -> Automatically after : xx:xx:xx option under the Animation Tab

For example, time them considering you start the present on a day @ lets say 9 a.m .. Then start counting the slide advances in hours.. and append accordingly.. U can use a excel sheet to calculate time advances..

Otherwise, if you want it to take the system time etc.. VBA would need to kick in, but looking at your example.. I think smartly changing hours should do the trick.. !

 

[billx]

thanks

but how do i get it to change the times from excel according to the date
do i have to create a slide for each day
can i have powerpoint pull the times from excel and display in slide with one standard slide

 

[Sal Paradise]

In your excel sheet, create a sheet called 'current' that will automatically pull whatever data is current. Link that sheet into PowerPoint. Now whenever you open PowerPoint, it will ask you if you want to update the links in your presentation. If you want the latest data click 'OK', if you want to keep the old data hit 'Cancel.'

Whenever given the option between diddling with data in Excel vs. diddling with it in PowerPoint, for task automation it is almost always easier to mess with Excel than to do it in Powerpoint.