Solved

How to Automatically Create Quad Slides from multiple Spreadsheets

Posted on 2008-06-24
4
2,135 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Gain an elementary understanding of Blockchain technology.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

691 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