Log In
Register
Home
Active Member
November 9, 2021
Offline
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.
Active Member
November 9, 2021
Offline
Sreenshot attached
Active Member
November 9, 2021
Offline
can someone please help me on this. I thought there are experts in this forum. Cant see a single response.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
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
Trusted Members
October 18, 2018
Offline
Thought this might be beneficial
Active Member
November 9, 2021
Offline
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.
1 Guest(s)
