copy data from excel and paste as picture in powerpoint vba code

nikhil0311

Board Regular
Joined
May 3, 2013
Messages
197
Office Version
  1. 2013
Platform
  1. Windows
sheet1 have the data.

I want a vba code to copy and paste data from excel to powerpoint 2010 as picture.

I already have a powerpoint file so i don't want to paste it in a new powerpoint but in an existing powerpoint file in different slides starting from slide 0 to N no of slides.

excel workbook sheet1 range is ("J1:cd47") please note that the range should be dynamic. the starting range is fixed i.e. j1 to cd1
but the count of rows may increase/decrease.

formating in powerpoint

size & rotate

height = 7.26
width = 9.36
rotation = 0

scale
height = 30%
width = 36%

position

position on slide

Horizontal = 0.08 from = top left corner
vertical = 0.74 from = top left corner

let me know if this is doable. Thanks in advance.
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Forum statistics

Threads
1,214,920
Messages
6,122,276
Members
449,075
Latest member
staticfluids

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