• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel to PowerPoint Paste with Keep Source Formatting

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
>>> use code - tags <<<
Code:
      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 help
 

Attachments

  • Excel to PowerPoint Paste with Keep Source Formatting.xlsm
    23.9 KB · Views: 1
  • keep-source-formatting.png
    keep-source-formatting.png
    2.4 KB · Views: 4
Last edited by a moderator:
Back
Top