Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > PowerPoint

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-11-2014, 05:57 PM
5amuel 5amuel is offline Windows XP Office 2007
Novice
 
Join Date: Jul 2013
Posts: 3
5amuel is on a distinguished road
Question Paste Excel chart with embeded workbook: PowerPoint for Mac

Hi
The following VBA code pastes Excel graphs to PowerPoint with the *workbook embeded* (same as clicking Paste Special -> Keep source formatting and embed workbook.



Can anyone assist in translating this code into Excel for Mac 2011? It breaks on "ExecuteMso"

Code:
Public PPApp As PowerPoint.Application
Public PPPres As PowerPoint.Presentation
Public PPSlide As PowerPoint.Slide
Sub ExcelToExistingPowerPoint()
    ActiveSheet.Select
    ActiveSheet.Copy
    ActiveSheet.Shapes(xChart).Copy
    Set PPSlide = PPPres.Slides.Add(PPPres.Slides.Count + 1, 2)
    PPSlide.CustomLayout = PPPres.Designs(1).SlideMaster.CustomLayouts(2)
    PPApp.ActiveWindow.View.GotoSlide PPSlide.SlideIndex
    PPSlide.Shapes.Placeholders(3).Select msoTrue
    PPApp.CommandBars.ExecuteMso "PasteExcelChartSourceFormatting"
End Sub
Thanks in advance!
Reply With Quote
  #2  
Old 02-16-2014, 02:01 AM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,471
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

ExecuteMso was added to Office 2010, but VBA in Office 2011 is more likely to be based on Office 2007. Therefore, you'll need to use only the methods available in Office 2007 & earlier. Not being a PowerPoint specialist, though, I can't advise on that.

I'll move the thread to the PowerPoint forum in the hope someone there will have an answer.

PS: See also http://www.mrexcel.com/forum/general...-2010-a-2.html
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Tags
chart, embed, mac

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Way to lock a workbook but still allow moving datapoints on a chart? omahadivision Excel Programming 1 01-31-2013 11:33 PM
Height and Width blank - Excel Chart in Powerpoint Metronome PowerPoint 1 04-06-2012 06:20 AM
Chart from Excel to Powerpoint narendra1302 PowerPoint 2 04-05-2012 03:19 AM
option Paste special...as 'Microsoft Excel Chart Object' NOT available Intruder PowerPoint 0 12-24-2010 06:28 AM
Paste chart from Excel bielak01 Word 4 04-29-2009 02:42 PM


All times are GMT -7. The time now is 07:52 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft