• 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.

Pasting a table from Excel to Powerpoint in original format (which is editable)

Rameez Sarang

New Member
Hi,

I have created a macro which paste a table from excel to Powerpoint. I want the table to be editable in PPT when it gets pasted. I am currently using the code - ppPasteEnhancedMetafile which it not editable and when I paste it using the code ppPasteDefault, ppPasteHTML or ppPasteSourceFormatting, the excel lines & columns appear in the table and the alignment goes for a toss.

I am attaching a screenshot for the same.

Could someone please guide or provide a code to paste the table as editable while retaining the Original format.

Thanks.
 

Attachments

Rameez Sarang

New Member
Need help Please. I am using the below code for pasting the table but its not editable on PPT

>>> use code - tags <<<
Code:
Sub OpenPPTNew()


'---------------------- Slide Begin------------------------
 
    'Copy paste excel table
  
        Set PPSlide = PPPres.Slides
        ThisWorkbook.Activate
        ThisWorkbook.Sheets("Sheet1").Range("A4:I15").Copy
        PPApp.Activate
        PPSlide.Select
        PPPres.Windows(1).View.PasteSpecial ppPasteEnhancedMetafile
        Application.CutCopyMode = False
Exit Sub


End Sub
 
Top