Andrew_1171
New Member
- Joined
- Feb 27, 2008
- Messages
- 10
Good morning,
I am trying to copy a range of cells into a PowerPoint slide, but the catch is, I would like them to be editable once they're in ppt.
I found some helpful info at the links below, but everything seems to point to copying the data as a picture.
Here is the code I have currently. Does anyone know how I can modify to create an editable range in the Powerpoint slide? Thanks! Andrew
Application.ScreenUpdating = True
Sheets("Template").Range("A1:P31").CopyPicture appearance:=xlScreen, Format:=xlBitmap
PPSlide.Shapes.Paste.Select
http://peltiertech.com/Excel/XL_PPT.html
http://www.mrexcel.com/forum/showthread.php?t=561594&highlight=powerpoint
I am trying to copy a range of cells into a PowerPoint slide, but the catch is, I would like them to be editable once they're in ppt.
I found some helpful info at the links below, but everything seems to point to copying the data as a picture.
Here is the code I have currently. Does anyone know how I can modify to create an editable range in the Powerpoint slide? Thanks! Andrew
Application.ScreenUpdating = True
Sheets("Template").Range("A1:P31").CopyPicture appearance:=xlScreen, Format:=xlBitmap
PPSlide.Shapes.Paste.Select
http://peltiertech.com/Excel/XL_PPT.html
http://www.mrexcel.com/forum/showthread.php?t=561594&highlight=powerpoint