Forum

Excel to PowerPoint...
 
Notifications
Clear all

Excel to PowerPoint Paste with Keep Source Formatting

2 Posts
2 Users
0 Reactions
324 Views
(@kpmsivaprakasam2003)
Posts: 15
Eminent Member
Topic starter
 
Hi i am using the excel 2013

I activated the excel and PowerPoint with 2 nos empty slides

Sheets "1" and "2" data range copy and paste to PowerPoint

this code paste with image, I need Paste with "Keep Source Formatting"

'Paste to PowerPoint and position
On Error Resume Next
Set shp = myPresentation.Slides(MySlideArray(x)).Shapes.PasteSpecial(DataType:=2) 'Excel 2007-2010
On Error GoTo 0

Please modification this code

thanks for your helpkeep-source-formatting.png

 
Posted : 05/01/2021 5:49 am
(@catalinb)
Posts: 1937
Member Admin
Share: