MrLookout9
New Member
- Joined
- Jun 25, 2011
- Messages
- 27
Hello and thank you for your expertise.
I am creating a macro that moves charts/ data from Excel to Powerpoint. I have been given the feedback that the created PowerPoint is too large. When I paste excel data into powerpoint, it is embedding the entire spreadsheet.
If I (outside of vba, just manually) copy cells A1:C3 and go to PowerPoint and click PasteSpecial, Keep Source Formatting, it works pefectly. The data is brought in, is editable, and nothing is embedded.
*Note: A picture (ppPastePNG) will not work, as the PP must be editable.
Sheets("Sheet1").Select
Sheets("Sheet1").Range(Cells(1, 1), Cells(3, 3)).Select
Selection.Copy
PPSlide1.Shapes.PasteSpecial DataType:=ppPasteOLEObject, Link:=msoCTrue
Link - msoCTrue embeds the data. msoFalse creates a non-editable picture.
I am creating a macro that moves charts/ data from Excel to Powerpoint. I have been given the feedback that the created PowerPoint is too large. When I paste excel data into powerpoint, it is embedding the entire spreadsheet.
If I (outside of vba, just manually) copy cells A1:C3 and go to PowerPoint and click PasteSpecial, Keep Source Formatting, it works pefectly. The data is brought in, is editable, and nothing is embedded.
*Note: A picture (ppPastePNG) will not work, as the PP must be editable.
Sheets("Sheet1").Select
Sheets("Sheet1").Range(Cells(1, 1), Cells(3, 3)).Select
Selection.Copy
PPSlide1.Shapes.PasteSpecial DataType:=ppPasteOLEObject, Link:=msoCTrue
Link - msoCTrue embeds the data. msoFalse creates a non-editable picture.
