Create a Macro whcich take data graphs from excel and paste it into PPT

**sameeru** · 03-01-2013, 08:32 AM

Hi Team

Im new to VBA

i want to create a macro which safe my time of copying graphs from excel to PPT . I have 6 graphs which need to paste inn the PPT diffrent slides

Can anyone help me in this.

Thanks
Sam

**xlbiznes** · 03-01-2013, 09:28 AM

Have a look at this

http://stackoverflow.com/questions/9...powerpoint-vba

**sameeru** · 03-01-2013, 09:48 AM

Not getting it

i m attching sample sheet

you can edit in that

**xlbiznes** · 03-01-2013, 10:18 AM

Hi,

Attaches is the solution, provided from the code of Drew Kesler.

Hope this helps.

**sameeru** · 03-01-2013, 10:27 AM

Thanks a lot

Just how to run that i need to go to the VBA module and then run the macro

any shortcut key that need to press to run the macro when the sheet open like CTRL + U like that

**xlbiznes** · 03-01-2013, 10:34 AM

If you can see the Macro button , simply click on that and it would display a list of macros. Select Sheet1.CreatePowerPoint and then click on run.

In case you do not see the macro button , you need to enable the developers tab by right clicking on the office button (top left corner) and then click customize quick access toolbar.

Then click on popular and then enable Show developer tab on the ribbon.