Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-09-2015, 05:35 AM
Vallin Vallin is offline Insert a Excel table in an existing PowerPoint table Windows 7 64bit Insert a Excel table in an existing PowerPoint table Office 2013
Novice
Insert a Excel table in an existing PowerPoint table
 
Join Date: Mar 2015
Posts: 2
Vallin is on a distinguished road
Default Insert a Excel table in an existing PowerPoint table

Hi,

I'm would like to insert a selected excel range[ActiveSheet.Range("A4:E" & NbItems).Copy] in an empty PowerPoint table [2 rows, two columns]. If I do it manually it works perfectly so I beleive that this is possible to acheive with VBA

So what I did is the following

With PPtApp
.ActivePresentation.Slides(.ActivePresentation.Sli des.count - 1).Shapes(3).Table.Cell(1, 1).Select
Selection.PasteSpecial DataType:=ppPasteDefault
End With

"Selection.PasteSpecial DataType:=ppPasteDefault" doesn't work. I've VBA message : Run-time error '1004': Application-defined or object-defined error



Thanks a lot in advance for your support!
Reply With Quote
  #2  
Old 03-09-2015, 06:25 AM
Vallin Vallin is offline Insert a Excel table in an existing PowerPoint table Windows 7 64bit Insert a Excel table in an existing PowerPoint table Office 2013
Novice
Insert a Excel table in an existing PowerPoint table
 
Join Date: Mar 2015
Posts: 2
Vallin is on a distinguished road
Default

So finally I found the answer!

.ActiveWindow.View.Paste
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert a Excel table in an existing PowerPoint table Insert a Word Table into an Excel cell Kapoof Excel 1 02-18-2014 02:12 PM
Copy Excel data into an existing Word Table JJG Word 1 12-18-2013 05:41 PM
Insert table in document - automatically updates second table in summary? Mechanic Word 2 08-01-2012 09:44 PM
Need help to insert a picture (.jpg) into slide 1 of an existing PowerPoint CatMan PowerPoint 3 04-24-2012 01:25 PM
Linking Excel Table to Powerpoint gsteveli PowerPoint 0 05-25-2011 07:50 PM

Other Forums: Access Forums - Senior Forums

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


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