I have a VBA macro in Excel wich generates several rectangles shapes of different sizes and colours according to some data I load onto a spreadsheet.
I am looking for some code to select all the shapes in the Excel active Sheet, and then paste them into a powerpoint file.
Idealy, the code would ask to select an existing Powerpoint file, open it, add a blank slide at the end and paste the shapes there.
This is probably something very simple, but I could not find any hep online.
Most of the time, people are looking to copy/paste a chart, and want to paste as a picture in order to keep the powperpoint file at a reasonnable size.
I am not looking for pasting as a picture, I need to keep the shapes objects so that they can then be modified manually in powerpoint if required by the final user.
The built-in macro recorder looses the track and stops recording when I paste in powerpoint.
Your suggestions are very much appreciated.