For experts only: how to copy-paste from Excel to PowerPoint, AND NOT LOSE PowerPoint TABLE FORMAT?

[niccoflo]

Hello,

the problem is simple but there is no online solution. Is there a VBA code that I can apply to power point or excel that allow me to:

- Copy a table from Excel
- Paste it in a Previously Formatted Power Point table

In other words, I already have a huge table in Power Point that is already formatted (in size, cells margins, colours, and so on) and I only need to copy-paste the Excel values into such table, without losing Power Point table format.

Thanks a lot

 

[Michael M]

I'm not an expert, but....

home tab paste button use destination styles. not edit paste special

AND as we don't know what version of Excel, PowerPoint and the platform you are using.
Please update your details so experts can identify the type of answer to provide 1

 

[Yongle]

This is the correct syntax to write value 50 to a cell in a powerpoint table
ActivePresentation.Slides(2).Shapes(1).Table.Cell(2, 2).shape.TextFrame.TextRange.Text = 50

One way would be to loop through all the cells in the Excel table and write the values to the equivalent cell in your powerpoint table
Pseudo code

For each r(ow) in exceltable
for each c(olumn) in exceltable
   ActivePresentation.Slides(2).Shapes(1).Table.Cell(r, c).Shape.TextFrame.TextRange.Text = exceltable.cells(r , c).Value
next c
next r

Let me know if you require further help

 

[niccoflo]

I'm not an expert, but....

home tab paste button use destination styles. not edit paste special

AND as we don't know what version of Excel, PowerPoint and the platform you are using.
Please update your details so experts can identify the type of answer to provide 1

Note that I was aware of "use destination styles", but as you might know, this does not work properly, and you can try it yourself