Macro to udpate and dislpay file path before save?

Hi,

I've very new to macros, and really need some help. Does anyone know how to
make this macro (from Microsoft's knowlegde base) run automatically before
the presentation is saved?

Sub UpdatePath()

' Macro to add the path and file name to each slide's footer.
Dim PathAndName As String
Dim FeedBack As Integer

' Place a message box warning prior to replacing footers.
FeedBack = MsgBox( _
"This Macro replaces any existing text that appears " & _
"within your current footers " & Chr(13) & _
"with the presentation name and its path. " & _
"Do you want to continue?", vbQuestion + vbYesNo, _
"Warning!")

' If no is selected in the dialog box, quit the macro.
If FeedBack = vbNo Then
End
End If

' Gets the path and file name and converts the string to lowercase.
PathAndName = LCase(ActivePresentation.Path & "\" & _
ActivePresentation.Name)

' Checks whether there is a Title Master, and if so, updates the
' path.
If ActivePresentation.HasTitleMaster Then
With ActivePresentation.TitleMaster.HeadersFooters
With .Footer
.Text = PathAndName
End With
End With
End If

' Updates the slide master.
With ActivePresentation.SlideMaster.HeadersFooters
With .Footer
.Text = PathAndName
End With
End With

' Updates the individual slides that do not follow the master.
Dim X As Integer
For X = 1 To ActivePresentation.Slides.Count
With ActivePresentation.Slides(X).HeadersFooters
With .Footer
.Text = PathAndName
End With
End With
Next

End Sub


Any help would be greatly appreciated.

Nick

>
> I've very new to macros, and really need some help. Does anyone know how to
> make this macro (from Microsoft's knowlegde base) run automatically before
> the presentation is saved?

What version of PPT are you using? PPT 2003 (and possibly earlier) support a
PresentationBeforeSave event that you can respond to using an add-in. You'd
trap the event and in the event code, call the UpdatePath subroutine.

There's more info about event handling here:

Make your VBA code in PowerPoint respond to events
[URL="http://www.pptfaq.com/FAQ00004.htm"]http://www.pptfaq.com/FAQ00004.htm[/URL]

>
> Sub UpdatePath()
>
> ' Macro to add the path and file name to each slide's footer.
> Dim PathAndName As String
> Dim FeedBack As Integer
>
> ' Place a message box warning prior to replacing footers.
> FeedBack = MsgBox( _
> "This Macro replaces any existing text that appears " & _
> "within your current footers " & Chr(13) & _
> "with the presentation name and its path. " & _
> "Do you want to continue?", vbQuestion + vbYesNo, _
> "Warning!")
>
> ' If no is selected in the dialog box, quit the macro.
> If FeedBack = vbNo Then
> End
> End If
>
> ' Gets the path and file name and converts the string to lowercase.
> PathAndName = LCase(ActivePresentation.Path & "\" & _
> ActivePresentation.Name)
>
> ' Checks whether there is a Title Master, and if so, updates the
> ' path.
> If ActivePresentation.HasTitleMaster Then
> With ActivePresentation.TitleMaster.HeadersFooters
> With .Footer
> .Text = PathAndName
> End With
> End With
> End If
>
> ' Updates the slide master.
> With ActivePresentation.SlideMaster.HeadersFooters
> With .Footer
> .Text = PathAndName
> End With
> End With
>
> ' Updates the individual slides that do not follow the master.
> Dim X As Integer
> For X = 1 To ActivePresentation.Slides.Count
> With ActivePresentation.Slides(X).HeadersFooters
> With .Footer
> .Text = PathAndName
> End With
> End With
> Next
>
> End Sub
>
> Any help would be greatly appreciated.
>
> Nick


==============================
PPT Frequently Asked Questions
[URL="http://www.pptfaq.com/"]http://www.pptfaq.com/[/URL]

PPTools add-ins for PowerPoint
[URL="http://www.pptools.com/"]http://www.pptools.com/[/URL]

Don't Miss the PPTLive User Conference! Atlanta | Oct 11-14