macro help needed

C

Chris

Hi. I have 2 power point presentations in which the
slides are perfectly aligned. One is just a later version
of the other with a bunch of minor tweaks throughout.
They are essentially the same though (same # of slides,
same position of the slides, etc.). The problem is that
my older version has all of the speaker notes in the notes
section.

Is there a macro I can run that will copy over the notes
from 1 presentation to the other without having to cut and
paste each and every slide?

Thanks in advance.
 
B

Bill Dilworth

OK, here's a macro for you. You will need to have both presentations
(source and destination) open to male this work.

Post back with complications.

=====Begin Macro Code=======
Option Explicit

Sub MoveNotes()
'
' Copyright Bill Dilworth 2004
' All rights reserved
'
Dim X As Integer
Dim Dummy As String
Dim StrNum As String
Dim ToNum As Integer
Dim FromNum As Integer

Dummy = MsgBox("This will take all" & _
"the notes from one present" & _
"ation and " & vbCr & "comp" & _
"letely overw" & _
"rite the notes in the dest" & _
"ination presentation." & vbCr & _
"Please exit now if you do " & _
"not want to do this." & vbCr & _
vbCr & " Exit this routine?", _
vbExclamation + vbYesNo + _
vbDefaultButton1, "Confirmation")
If Dummy <> vbNo Then Exit Sub
Dummy = ""

For X = 1 To Presentations.Count
Dummy = Dummy & vbCr & _
Str(X) & " - " & _
Presentations(X).Name
Next X

StrNum = InputBox("Enter the n" & _
"umber of the presentation" & _
" with the source notes to" & _
"be copied? " & vbCr & Dummy, _
"Notes Source", "1")
If IsNumeric(StrNum) Then
FromNum = Val(StrNum)
Else
MsgBox "Bad Number"
Exit Sub
End If

StrNum = InputBox("Now input the" & _
"number of the presentation" & _
"to send the notes to:" & vbCr & _
vbCr & Dummy, "Notes Destin" & _
"ation", "2")
If IsNumeric(StrNum) Then
ToNum = Val(StrNum)
Else
MsgBox "Bad Number"
Exit Sub
End If

If X - 1 < FromNum Or X - 1 < ToNum Then
MsgBox "Bad presentation number entered."
Exit Sub
End If

If FromNum = ToNum Then
MsgBox "Source and destinati" & _
"on files can not be the same file."
Exit Sub
End If

If Presentations(FromNum).Slides. _
Count <> Presentations(ToNum). _
Slides.Count Then
Dummy = MsgBox("Source and des" & _
"tination presentations contai" & _
"n different number of slides." & _
vbCr & "Excess notes from sour" & _
"ce will be discarded. Counti" & _
"ne?", vbQuestion + vbYesNo, _
"Possile Data Loss")
If Dummy = vbNo Then Exit Sub
End If

For X = 1 To Presentations(FromNum). _
Slides.Count
Presentations(ToNum).Slides(X). _
NotesPage.Shapes(2). _
TextFrame.TextRange.Text = _
Presentations(FromNum). _
Slides(X).NotesPage. _
Shapes(2).TextFrame. _
TextRange.Text
Next X

MsgBox "Completed. Please check yo" & _
"ur presentation prior to saving."

End Sub
======End Code=============

--
Bill Dilworth, Microsoft PPT MVP
===============
Please spend a few minutes checking vestprog2@
out www.pptfaq.com This link will yahoo.
answer most of our questions, before com
you think to ask them.

Change org to com to defuse anti-spam,
ant-virus, anti-nuisance misdirection.
..
..
 
J

John Langhans [MSFT]

[CRITICAL UPDATE - Anyone using Office 2003 should install the critical
update as soon as possible. From PowerPoint, choose "Help -> Check for
Updates".]
[TOP ISSUE - Are you having difficulty opening presentations in PowerPoint
that you just created (you can save, but not open)? -
http://support.microsoft.com/?id=329820]

Hello,

PowerPoint doesn't provide the functionality that you are looking for
without resorting to VBA or add-ins or manual workarounds (for example
multiple copies <using Office clipboard> followed by multiple pastes).

If you (or anyone else reading this message) think that it's important that
PowerPoint provide this kind of functionality (without having to resort to
VBA or add-ins), don't forget to send your feedback (in YOUR OWN WORDS,
please) to Microsoft at:

http://register.microsoft.com/mswish/suggestion.asp

It's VERY important that, for EACH wish, you describe in detail, WHY it is
important TO YOU that your product suggestion be implemented. A good wish
submssion includes WHAT scenario, work-flow, or end-result is blocked by
not having a specific feature, HOW MUCH time and effort ($$$) is spent
working around a specific limitation of the current product, etc. Remember
that Microsoft receives THOUSANDS of product suggestions every day and we
read each one but, in any given product development cycle, there are ONLY
sufficient resources to address the ones that are MOST IMPORTANT to our
customers so take the extra time to state your case as CLEARLY and
COMPLETELY as possible so that we can FEEL YOUR PAIN.

IMPORTANT: Each submission should be a single suggestion (not a list of
suggestions).

John Langhans
Microsoft Corporation
Supportability Program Manager
Microsoft Office PowerPoint for Windows
Microsoft Office Picture Manager for Windows

For FAQ's, highlights and top issues, visit the Microsoft PowerPoint
support center at: http://support.microsoft.com/default.aspx?pr=ppt
Search the Microsoft Knowledge Base at:
http://support.microsoft.com/default.aspx?pr=kbhowto

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top