https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Data-filter-for-SASGraph-in-MS-PowerPoint-Presentation/m-p/11083#M354 Hi:<BR /> You might consider populating your PowerPoint presentation from a Stored Process (SP) -- if, for example, you used BY group processing or some SAS/Graph process that created multiple graphs usually PowerPoint puts each graph and each table on a separate slide.<BR /> <BR /> Your data filters could become input parameters to the SP -- so you'd select them one time -- when you go to run the SP -- and then you could have code which would use those data filters and return the results -- with the graphs already filtered -- to your PowerPoint session.<BR /> <BR /> Someone who knows SAS should be able to see what task you're doing in PPT with the Add-in and then replicate that task, with code, as a Stored Process. <BR /> <BR /> You probably could do this with VBA and some kind of custom script that was a layer on top of the Add-in results, but personally, I'd try the Stored Process route first.<BR /> <BR /> cynthia Tue, 15 Apr 2008 15:29:43 GMT Cynthia_sas 2008-04-15T15:29:43Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Data-filter-for-SASGraph-in-MS-PowerPoint-Presentation/m-p/11082#M353 Hi,<BR /> <BR /> im working with SAS Add-In for creation and composite the PowerPoint presentation, based on my SAS data. I have approximatly hundred of presentation for product, department and etc division. Difference between presentation it's just filter for data table. Hundred times i must to do the next steps:<BR /> 1. Open presentation.<BR /> 2. Find 2D Bar Chart and click "Property"<BR /> 3. On "Property" window select "Data" tab<BR /> 4. on "Data" tab (middle of window) click "Change..."<BR /> 5. Change the data filter, save it and refresh presentation.<BR /> <BR /> I think it's not "better" way for creating a equialent presentations.<BR /> Has the any VBA code example for my issue? Or what VBA class i must tu use for data filter changing? Tue, 15 Apr 2008 12:28:21 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Data-filter-for-SASGraph-in-MS-PowerPoint-Presentation/m-p/11082#M353 Kuzmenkov 2008-04-15T12:28:21Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Data-filter-for-SASGraph-in-MS-PowerPoint-Presentation/m-p/11083#M354 Hi:<BR /> You might consider populating your PowerPoint presentation from a Stored Process (SP) -- if, for example, you used BY group processing or some SAS/Graph process that created multiple graphs usually PowerPoint puts each graph and each table on a separate slide.<BR /> <BR /> Your data filters could become input parameters to the SP -- so you'd select them one time -- when you go to run the SP -- and then you could have code which would use those data filters and return the results -- with the graphs already filtered -- to your PowerPoint session.<BR /> <BR /> Someone who knows SAS should be able to see what task you're doing in PPT with the Add-in and then replicate that task, with code, as a Stored Process. <BR /> <BR /> You probably could do this with VBA and some kind of custom script that was a layer on top of the Add-in results, but personally, I'd try the Stored Process route first.<BR /> <BR /> cynthia Tue, 15 Apr 2008 15:29:43 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Data-filter-for-SASGraph-in-MS-PowerPoint-Presentation/m-p/11083#M354 Cynthia_sas 2008-04-15T15:29:43Z