Copy range from multiple workbooks and past as image in PPT

I won't give it a try since I don't have the pieces to play with. However, the attachment contains the information you need to do it.

I suggest writing a program to bring the ranges into a single workbook and then use the table to put them on the PowerPoint spreadsheet.

Will the Presentation already exist?

The program depends on the existence of a "template" PowerPoint presentation. The template is actually a regular PowerPoint presentation with all the titles, text, etc. already filled in. What is left blank are the charts and ranges you want to add.

The code takes the template and makes a copy of it with a date stamp and then fills in this copy.

The code fills in the blanks with the definitions you give it on the Object Map page. The object map page tells the program what sheet to go in the workbook to find what you want to copy, what range or chart on the page to copy, whether it is a Range or Chart, what PowerPoint page to put it on, and how to position and size it on the page.

The range can be a physical range as indicated in the example, or it can be a named range.

The code also contains sample code to substitute text in the template or the footers.

I am fond of using named ranges, the Control Panel sheet has several that are used in the code.

You are sort of on your own as to code what text you'll need to substitute. However you should be able to use the parts of the code that put the charts and ranges on the PP sheets as is. All you'll need to do for that is fill out the object map.

@Mad-Dog: I should mention, The part of the program that positions and sizes the objects is in inches. There are 72 pixels per inch in a PP slide. If I am doing my math correctly, there are 28.35 pixels in a cm. I think this means to use cm in the object map, change the 72 in this part of the code to 28.35.

Please Login or Register  to view this content.