Hi guys,
I can't figure out how to write a powerpoint marco about yesterdays date. I have a ppt about yesterdays KPIs and I want to achieve the following:
- Select the existing text box that always shows a "date" and update it to yesterday's date, unless the current day is a monday, then it should be updated to last friday. The format "day, dd.mm.yyyy" should be used.
- it would be perfect if the macro starts the moment I open the ppt or save it but if this is not possible, it would be great if i could update it by clicking on a "button"
- the text box should appear on every slide of my ppt
I would really appreaciate your help.
Cheers,
Rob
Reply With Quote
