Hi All,
Hope this is not a silly question...but I'm a newbie to VBA and am stuck...I have an Excel 2007 Workbook that has multiple worksheets. Several of the worksheets contain charts that I need for a weekly report that is distributed in PowerPoint 2007. 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 (one chart in each of 4 quadrants).
Ex.
Sheet 1 has 4 charts (Chart 1, Chart 2, Chart 3, Chart 4) – these are pasted into 4 quadrants on slide 2 in the PowerPoint presentation
Sheet2 has 4 charts (Chart 1, Chart 2, Chart 3, Chart 4) – these are pasted into 4 quadrants on slide 3 in the PowerPoint presentation
Sheet 3 has 4 charts (Chart 1, Chart 2, Chart 3, Chart 4) – these are pasted into 4 quadrants on slide 4 in the PowerPoint presentation

In my VBA code for the Excel workbook, I have some code written in to automatically open up my PowerPoint master (a presentation set up like I need it, except for blank spaces where the charts are to go). This works great and the file opens to the first slide...but I can’t figure out how to copy each of the charts from Excel and get them onto the correct slide #'s in the presentation. Each of the 4 charts from Sheet 1 and paste/special values (enhanced metafile) them into my existing presentation onto slide 2, the 4 charts from Sheet 2 onto slide 3 and so on. I know that when they are pasted in, I need to adjust them to the appropriate height and width and position on the screen as well. In summary, what I am wanting to do is be able to push the button in Excel (linked to my PPT module) and have PowerPoint open automatically (which it does) and update the charts (which it does not yet do).

Any help would be GREATLY appreciated!!