Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-11-2014, 05:57 PM
5amuel 5amuel is offline Paste Excel chart with embeded workbook: PowerPoint for Mac Windows XP Paste Excel chart with embeded workbook: PowerPoint for Mac Office 2007
Novice
Paste Excel chart with embeded workbook: PowerPoint for Mac
 
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 Paste Excel chart with embeded workbook: PowerPoint for Mac Windows 7 32bit Paste Excel chart with embeded workbook: PowerPoint for Mac Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
chart, embed, mac

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Paste Excel chart with embeded workbook: PowerPoint for Mac Way to lock a workbook but still allow moving datapoints on a chart? omahadivision Excel Programming 1 01-31-2013 11:33 PM
Paste Excel chart with embeded workbook: PowerPoint for Mac Height and Width blank - Excel Chart in Powerpoint Metronome PowerPoint 1 04-06-2012 06:20 AM
Paste Excel chart with embeded workbook: PowerPoint for Mac 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 Excel chart with embeded workbook: PowerPoint for Mac Paste chart from Excel bielak01 Word 4 04-29-2009 02:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:33 PM.


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