Hi all,
I am trying to copy a table from excel to powerpoint. I just want it to paste the same way that it does when I just hit Ctrl-V on my computer, but my code(below) keeps throwing an error unless I paste as a picture, or an OLE object. I don't want it linked, and I need to be able to modify the table in ppt. Any ideas? I've been struggling with this for a while now. Thanks!
Object1Name = Worksheets("Sheet" & i).Cells(6, 3)
'Set Object1 = Range(Object1Name)
Range(Object1Name).Copy
slide(3).Shapes.PasteSpecial ppPasteOLEObject, msoFalse, , , , msoFalse
I am trying to copy a table from excel to powerpoint. I just want it to paste the same way that it does when I just hit Ctrl-V on my computer, but my code(below) keeps throwing an error unless I paste as a picture, or an OLE object. I don't want it linked, and I need to be able to modify the table in ppt. Any ideas? I've been struggling with this for a while now. Thanks!
Object1Name = Worksheets("Sheet" & i).Cells(6, 3)
'Set Object1 = Range(Object1Name)
Range(Object1Name).Copy
slide(3).Shapes.PasteSpecial ppPasteOLEObject, msoFalse, , , , msoFalse