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 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 In Advance.
Sreenshot attached
can someone please help me on this. I thought there are experts in this forum. Cant see a single response.
Hi Rameez,
There is no acreenshot attached, make sure you press the Start Upload button after you select files.
have you tried recording a macro while doing the paste operation manually?
Try with:
DataType:=ppPasteHTML, Link:=msoFalse
Thought this might be beneficial
https://www.excelforum.com/tips-and-tutorials/1364196-excel-to-powerpoint-xl2pp.html
Hi,
Thanks for the response.
I tried using DataType:=ppPasteHTML, Link:=msoFalse but the excel lines & columns appear in the table and the alignment goes for a toss.
Please can you suggest something else.
