• 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


  • 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

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.



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 <<<
Sub OpenPPTNew()

'---------------------- Slide Begin------------------------
    'Copy paste excel table
        Set PPSlide = PPPres.Slides
        PPPres.Windows(1).View.PasteSpecial ppPasteEnhancedMetafile
        Application.CutCopyMode = False
Exit Sub

End Sub