Copy Data from Excel to Powerpoint, *not as picture*

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
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
It seems like this would be the equivalent of doing Paste Special, HTML Format.

How do you do that in VBA, from Excel to Powerpoint? I've scoured the web, help!
 
Upvote 0

Forum statistics

Threads
1,224,521
Messages
6,179,291
Members
452,902
Latest member
Knuddeluff

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top