Hi everybody, I appreciate your help
Does anyone knows the best approach to copy a pivot table from an excel worksheet to a powerpoint slide using Vba, in a manner that I can resize the pivot table in the slide without losing too much quality.
For example, I was trying to copy the pivot table range and paste special as metafilepicture, but it´s pasting just part of the pivot , like if it has a limited size acceptable to copy.
Please Login or Register to view this content.
Hello can anybody helpe me, plz. ...
Perhaps the attachment and the link will help you out. Basically, you have to overlay the pivot table with a named dynamic range (that's what the link will show you how to do) and then use the pivot table function to copy and paste the named range into the PowerPoint.
http://www.utteraccess.com/wiki/Offs...Dynamic_Ranges
That's about as far as I can take it without seeing actual files (a sample excel book and sample powerpoint).
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.
I found a better explanation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks