Need to export charts to existing workbook
Hi All, I'm a newbie to VBA and am stuck.. I have worksheet with charts and i need to prepare monthly report . As of now, I am manually updating the PowerPoint slides by copying the charts from Excel and then pasting them as special values - picture (enhanced metafile) into the PowerPoint slide. I then have to manually adjust the size of them so that they will fit on the slide accordingly.
So what i want is ,
I need to export charts to an existing presentation tempalate

Ex Chart 1, 3, 4) – these are pasted into on slide 2 in the my presentation template.
(Chart 5, 7) – these are pasted into on slide 3 in the my presentation template.... So on

Your help will be greatly appreciated