I've done lots of automation between Excel and PowerPoint, including copying Chart objects and copying Excel data into the data table behind a PowerPoint Chart.
But I can't figure this one out. Using VBA I want to copy a formatted Excel range into a PowerPoint TABLE. I want to duplicate what I get when I manually copy the range, then manually paste into PPT, selecting the Keep Source Formatting option. It's a heat map, so very important to preserve formatting.
Once it's in PowerPoint, I need to be able to further manipulate the table, changing font sizes, adding rows, etc. all of which I know how to do. Where I'm stuck is getting it to come in as a table.
The following two options both copy the formatting of the source cells, but in one case it's just a picture and in another it's an OLE object I can't manipulate
In the past I've iterated through the range and copied the values into the cells of the PowerPoint table one at a time, but there has to be a better way.
Thanks for your suggestions.