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

[Rameez Sarang]

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.

 

[Rameez Sarang]

refer attachment

 

[Rameez Sarang]

can someone please assist?

 

[Rameez Sarang]

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

 

[anishms]

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

You are pasting as image (ppPasteEnhancedMetafile), then how will you be able to edit. Use ppPasteDefault instead

PPPres.Windows(1).View.PasteSpecial ppPasteDefault

 

[Rameez Sarang]

Thanks for the reply but I have tried this as well and its doesnt work. The formatting of the table gets distorted.

If you see my original query, I have mentioned it - "
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."

 

[Rameez Sarang]

Please close this request as there is no satisfactory response for this

 

[Rameez Sarang]

disappointed that nobody has any answer to this query. Kindly close it

 

[anishms]

Thanks for the reply but I have tried this as well and its doesnt work. The formatting of the table gets distorted.

If you see my original query, I have mentioned it - "
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."

Hi Rameez,
But the version I attached is working fine for me.
The table lines are shown only when I select the table