Hello,
I'm looking for a code / macro that would automate for me the following steps:
1. Create new, blank Power Point deck
2. Copy and paste as bitmaps charts from tab "Charts", each chart into a separate slide
For each slide, there should be a text above the chart - taken from each chart title
3. For the last slide, the slide should copy and paste excel table (keep source formatting) into the slide
Any help would be much appreciated.
Regards
Marcin
The following is a utility I developed. It basically takes charts and tables in excel, copies them and pastes them as metafile objects in Powerpoint. You need to supply the name of the PoerPoint "template," the desired output name, and a "map" that basically says, "Go to this Excel sheet, copy this object, put it on this Powerpoint sheet and position and size it."
The limitation is that it works with a fixed template. For my reporting, this works out fine, although I have one report where I have to delete the unused sheets.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks