View Single Post
 
Old 04-03-2012, 05:48 AM
Cosmo Cosmo is offline Windows Vista Office 2007
Competent Performer
 
Join Date: Mar 2012
Posts: 240
Cosmo is on a distinguished road
Default

I have done something very similar for one of our clients. Here's a brief idea of what I do:

I have a userform for the user to input data, which puts the entered data into the required places in the PPT file. Each shape in the presentation which will receive data is identified by an added 'tag' to the shape, e.g.
Quote:
ActivePresentation.Slides(1).Shapes("Chart 1").Tags.Add('Identifier', 'CurrentSalesChart')
('Identifier' is the name of the tag that identifies the shape as a target, and 'CurrentSalesChart' is the name of the specific shape.)

First, I loop through every shape in the presentation (on slides and master templates) to locate these tagged shapes. Then I show the user the userForm for data entry, and after the user enters their data, they click the 'apply' button on the form, which sets the data into the various charts and tables that were located, and saves the presentation under the account name and date.
Reply With Quote