How to Automatically Create Quad Slides from multiple Spreadsheets

Posted on 2008-06-24
Medium Priority
Last Modified: 2012-06-27
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.
Question by:rgautier
  • 2
  • 2
LVL 39

Accepted Solution

nutsch earned 2000 total points
ID: 21857540
Look at the attached excel file. It will take named ranges in excel and copy them to specific slides in Powerpoint. You define the position of your ppt presentation, your ranges and press the button. Let me know if this helps.

You can use this architecture to copy 4 named graphs x20 into one specific powerpoint slide, after defining left, top and width so they fit in the 4 spaces.
LVL 13

Author Comment

ID: 21865436
I ended up automating from within Powepoint (opening the spreadsheets with Excel Automation).  The only thing I was unable to do (see new open ticket from me) is create SmartArt from the TextRange (bulleted list) that I created.

The posted response from nutsch is one way to address the issue, but won't work for me as I need to open multiple Excel files all with the same chart objects (and names).

However I did take a very similar approach from the other angle.  Thanks for your help.
LVL 13

Author Closing Comment

ID: 31470097
While not applicable directly to my particular situation, the approach is good and would work in a different situation.
LVL 39

Expert Comment

ID: 21867327
I don't really understand in what way "open multiple Excel files all with the same chart objects (and names)" doesn't fit in my transfer file. You can put as many multiple excel files as you need, and the named ranges can be the same. In which way can't you use that solution for your purpose.


Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question