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
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
Have a look at this
http://stackoverflow.com/questions/9...powerpoint-vba
Happy Computing ,
Xlbiznes.
To show your appreciation please click *
Not getting it
i m attching sample sheet
you can edit in that
Hi,
Attaches is the solution, provided from the code of Drew Kesler.
Hope this helps.
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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks