WaxonWaxov
Board Regular
- Joined
- Apr 9, 2009
- Messages
- 141
Disclaimer: I hate PowerPoint, but my boss makes me use it.
OK,
How do I automate using VBA code the following:
1) When I open the "template" ppt file which has charts with data being linked to an external Excel file, the data should reflect the current data... it does not by default. You right-click "edit data" to get it to refresh.
2) Then I want the data sources for the charts to become static, not referencing the Excel file (similar to copy/paste special values in Excel)
3) then the ppt file should save itself with a new name as to not copy over the template file.
Make sense?
Sometimes I just want to scream "PowerPoint is not a reporting engine!"
thanks
OK,
How do I automate using VBA code the following:
1) When I open the "template" ppt file which has charts with data being linked to an external Excel file, the data should reflect the current data... it does not by default. You right-click "edit data" to get it to refresh.
2) Then I want the data sources for the charts to become static, not referencing the Excel file (similar to copy/paste special values in Excel)
3) then the ppt file should save itself with a new name as to not copy over the template file.
Make sense?
Sometimes I just want to scream "PowerPoint is not a reporting engine!"
thanks
