Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 10-18-2023, 05:00 PM
ElFinkEl ElFinkEl is offline Need Macro to Copy Notes from one PPT to another Mac OS X Need Macro to Copy Notes from one PPT to another Office 2016 for Mac
Novice
 
Join Date: Oct 2023
Posts: 1
ElFinkEl is on a distinguished road
Default Used to Work But Not Anymore

Quote:
Originally Posted by Dan_nn View Post
Hey Alex311, it looks like the only issue was using TextRange.PasteSpecial (ppPasteRTF)... I used the regular paste and it worked like a charm.

Here's my updated version (tested and working flawlessly)

Sub switchNotes()
Dim oTarget As Presentation
Dim oSource As Presentation
Dim i As Integer
On Error Resume Next
Set oTarget = Presentations("target.pptx")
Set oSource = Presentations("source.pptx")
For i = 1 To oSource.Slides.Count
oSource.Slides(i).NotesPage.Shapes(2) _
.TextFrame.TextRange.Copy
oTarget.Slides(i).NotesPage.Shapes(2) _
.TextFrame.TextRange.Paste
Next i
End Sub

Hoping it can help you and others as well.
I'm wondering if anyone can help me with this. I've used this macro a couple of times successfully, but now it is not working for me anymore. It just copies "1.7.2013". This is driving me nuts! Any advice appreciated.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
PowerPoint Macro - Copy and Replace pictures from one PPT to another PPT mrayncrental PowerPoint 2 06-09-2014 02:52 AM
Macro to copy formula from one cell to another anwar Excel Programming 1 04-25-2014 08:27 PM
Need Macro to Copy Notes from one PPT to another Word macro: copy from different tables into one table adisl Word VBA 4 03-25-2014 02:40 AM
Need Macro to Copy Notes from one PPT to another How to do an automation for copy paste, added new row (macro) jpol Excel Programming 1 03-01-2013 05:53 AM
Powerpoint copy notes no1_titch PowerPoint 0 09-07-2010 06:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:25 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft