How to Automatically Create Quad Slides from multiple Spreadsheets
Posted on 2008-06-24
I have 20 spreadsheets, each with a formulaic name "france_whole.xlsx", "london_whole.xlsx", etc..
In each spreadsheet, I have 4 chart worksheets that pertains to that subject: France, London, New York, etc. Each chart is on its own 'chart worksheet', meaning I told the chart to move to its own worksheet, and it displays properly in full screen mode.
I need to tell Powerpoint to open up each spreadsheet, cut the four graphs and put them on a 'quad' slide with the label 'France', 'London', 'New York', etc in the Title text. The quad slides should use a slide master.
I'm not sure the best way to do this, but I figure once it's done, I'll be able to run it every week, month, etc..so it should be automatic/linked to the spreadsheets.