Excel vba to powerpoint
Hi. I am running a macro from excel that will paste one powerpoint to another. I got it to paste, but it does not paste with the source formatting. Does anyone know how to do that?
Set pres1 = pp.Presentations.Open(LocationPath & "\Example.pptx")
Set pres2 = pp.Presentations.Add
pres1.Slides(1).Copy
pres2.Slides.Paste pres2.Slides.Count + 1
you will probably have to assign your slides to objects first
then
'Bring over slides design
New_sld.Design = Old_sld.Design
'Bring over slides custom color formatting
New_sld.ColorScheme = Old_sld.ColorScheme
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks