PPT Update Question

MR3

Board Regular
Joined
Jun 10, 2008
Messages
175
I have a Microsoft Power Point Presentation that is approximately 20 slides long. At the bottom of each slide contains the same date information, however its not in the actual footer.* My question is in regards to Updating the information on only the first slide but it auto-updates on all the other subsequent slides, when I modify the first slide.* Currently I have to update the information on each slide individually and its a really redundant task that
I feel can somehow be automated.* Any help or advice would be greatly appreciated.

Thanks in Advance
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
You could use a macro like the following:
Code:
Sub Update()
Dim Sld As Slide, Shp As Shape
With ActivePresentation
  For Each Sld In .Slides
    For Each Shp In Sld.Shapes
      If Not Shp.TextFrame Is Nothing Then
        If Shp.TextFrame.TextRange.Text Like "##/##/####" Then
          Shp.TextFrame.TextRange.Text = Format(Date, "DD/MM/YYYY")
        End If
      End If
    Next
  Next
End With
End Sub
As coded, the macro assumes the data is the only text in the relevant textbox, is in DD/MM/YYYY format, and is to be replaced with today's date in the same format.
 
Upvote 0

Forum statistics

Threads
1,225,669
Messages
6,186,346
Members
453,349
Latest member
neam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top