I am currently trying to identify a way in which I can copy charts from MS Excel over to MS PowerPoint by using macros.
I already have several charts within Excel and need to create some VB coding which will copy these charts, open PowerPoint and paste them into a new presentation.
Could anyone suggest a way of acheiving this task?