Solved

How to Automatically Create Quad Slides from multiple Spreadsheets

Posted on 2008-06-24
4
2,131 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

726 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