Paste from Excel to specific row and column in Powerpoint table

[gpb237]

The idea is to select a specific row and column in a table within PowerPoint and paste values from excel or from the clipboard.
I cannot get the macro to paste what I have already copied from the clipboard into the selected cells in the table.
I cannot get the macro to link to excel when I'm in a Powerpoint table. Seems like VBA is averse to ppt tables. The macro works fine up until I try to paste. Any thoughts?
Here is part of what I've written.

Sub Macro1 ()
Dim PowerpointApplication As Object, PowerpointPresentation As Object, PowerpointSlide As Object
Dim PowerpointTextbox As Object

ThisWorkbook.Sheets("Data for Powerpoint").Range("A4").Copy
PowerpointPresentation.Slides(1).Select
PowerpointSlide.Shapes("Table1").Table.Rows(2).Cells.Item(1).Select

Paste from clipboard or create link to excel???

End Sub

 

[sijpie]

VBA code to replace contents in a Powerpoint table using Excel data

I would like to copy Excel data into an existing Powerpoint table using VBA in order to keep the Powerpoint table formatting, e.g. I need a VBA code to open an existing PPT presentation, select a predefined slide let's say Slide(1), select the Table1 shape in Powerpoint and copy the Excel table...

www.mrexcel.com

 

[sijpie]

This is another good resource:

Working with PowerPoint tables

From the PowerPoint FAQ: Working with PowerPoint tables

www.pptfaq.com