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.