macro help needed

  • Thread starter Thread starter Chris
  • Start date Start date
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.
 
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.
..
..
 
Chris,
I am not a MVP and they might come up with a good
answer to your problem but I'll give you a really cool
workaround.
I use an application called "clipmate" that makes your
clipboard unlimited on how many things can be copied
or pasted. In other words I can copy 20 things, one
after the other, and all 20 are still on the clipboard
and then I can start at the top or bottom of the 'stack'
and choose Paste 20 times and they are all pasted
in in the correct order.
I forsee you being able to open your presentation that
has the notes and starting at the first slide you highlight
the notes and click copy (or CTRL C) and then go
to the next and so on till you've copied all notes. Then
open the presentation that doesn't have the notes and
paste each slide worth of notes one after the other till
they are all pasted.
Clipmate is shareware and can be found here:

http://www.thornsoft.com/clipmate6.htm

I use it so much I went ahead and registered my copy..
I love it. (I used it to transfer the text from Corel
Presentations slide shows to Powerpoint for my church)

Holler if I can help,
Scott
 
[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
 
Back
Top