[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2174
  • Last Modified:

How to Automatically Create Quad Slides from multiple Spreadsheets

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
rgautier
Asked:
rgautier
  • 2
  • 2
1 Solution
 
nutschCommented:
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
 
rgautierAuthor Commented:
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
 
rgautierAuthor Commented:
While not applicable directly to my particular situation, the approach is good and would work in a different situation.
0
 
nutschCommented:
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now