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

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 382
  • Last Modified:

Office Design for PPT DOC and XLS Integration

I'm looking for guidence on taking an Excel Spreadsheet that is designed to "collect data" in a client engagement and auto populating a Word Doc. and a Powerpoint  presentation.  I do not know if I should try to use "smart tags", put the three elements in the same folder on the desktop with a consistent "path" (multiple people will use this capability on different PCs)....... so I'm at the design phase of this project and wanted to reach out to EE to get some ideas on how to approach this.

In summary, information driven from Excel, will generate graphics and data for a presentation (Powerpoint) and a Executive Summary (Word).  I'm looking for design points.

Much thanks,

3 Solutions

I would suggest keeping the Word template, PP template plus the Excel file in the same folder. This way you don't have to hardcode the path. You could always refer to the path as Activeworkbook.Path.

Populating PPT and Doc is not a problem. If you can share all the three files then I can give you the exact code :)

Arno KosterCommented:
In general, you should first be designing the graphic and data in excel. When you have the charts, tables, summaries and such availabe, then you can export these in powerpoint and word documents.

This can be automated using VBA macro's, with which EE can assist you.
As Sid indicated to be able to effectively guide you in the right direction, it would be best if you have powerpoint and word templates available.
And since you're using Office 2010, you can leverage themes. This gives you access to the same fonts, colors and effects in Word, Excel and PPT, so that when you put the charts into PPT (whether manually or via VBA), they don't change colors because they're built on the same chassis to begin with.

Here's a broad overview of that: http://www.elijournals.com/premier/showArticle.asp?aid=26655&searchThisProdCode=2085 
Bright01Author Commented:
I will be posting a related question with sample files.  Thanks for getting me started.

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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