Solved

How to Automatically Create Quad Slides from multiple Spreadsheets

Posted on 2008-06-24
4
2,126 Views
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.
0
Comment
Question by:rgautier
  • 2
  • 2
4 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 500 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.
Transfer-XL-to-PPT.xls
0
 
LVL 13

Author Comment

by:rgautier
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.
0
 
LVL 13

Author Closing Comment

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

Expert Comment

by:nutsch
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.

Thomas
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
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 demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

806 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