Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Auckland, North Island, New Zealand
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts

    auto updating text (2000 SR1)

    We are producing a slide show for our company reception.

    How can I create an object on a slide that updates every day automatically?

    I want to show the result of:
    (today's date - start date)*250

    eg 25/6/02 - 22/6/02 = 3*250 = 750

    I need to be able to update the start date easily and today's date needs to update automatically every day. This maybe every time the slide show is run, but it is likely that the show will run continually so object would need to "recalculate" each time slide is displayed

  2. #2
    Lounger
    Join Date
    Jan 2001
    Location
    San Diego, California, USA
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: auto updating text (2000 SR1)

    Open an Excel worksheet.
    Label your columns:
    Today
    Attached Files Attached Files

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Location
    Auckland, North Island, New Zealand
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: auto updating text (2000 SR1)

    Thanks Ryan,

    I had achieved something similar using =Today() rather than now() (as the subtraction of dates works better).

    But the issue is still the automation, I have tried recording a macro in pp but still need to find out how to get it to run every time the slide is displayed and to then update the calc (F9) in excel from pp. Alternative would be to write a function (easy bit) in pp and then put this onto the slide, but no idea how to get the function onto the slide.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •