Paste from Excel to specific row and column in Powerpoint table

gpb237

New Member
Joined
Oct 27, 2015
Messages
25
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
 

Forum statistics

Threads
1,077,721
Messages
5,335,818
Members
399,051
Latest member
WPO

Some videos you may like

This Week's Hot Topics

Top