Excel and Powerpoint

[Guest]

I have approximately 50 different excel workbooks that I want to add to an
existing powerpoint presentation. I want to define where each sheet goes
instead of manually making that slide active. For example. I have chart A
and Chart B in Workbook A on the same sheet. I want to delete the Charts
that exist in the current powerpoint presentation and replace with Charts A
and B. Chart A goes on slide 21 and Chart B goes on Slide 8. Can someone
help me with this? I am not sure how do this through VBA.

 

[Jon Peltier]

This page may help get you started:

http://peltiertech.com/Excel/XL_PPT.html

- Jon

 

[Guest]

Jon,

Believe it or not, I found your information before this forum. The issues
that exist is that I am unable to paste as a picture to a specific slide in
an existing powerpoint presentation. In addition, I need to be able to
delete the "picture" that was already in that specific slide.

 

[Jon Peltier]

There are things you can do when you have a larger system in which you copy
multiple Excel objects to multiple PowerPoint slides.

First, you name the pasted objects with descriptive names, like "XLpic001"
and "XLpic002", as you paste them. When you update the slide, you check the
names of all objects on the slice, and any that start with "XLpic" get
deleted.

Then you might use a table in Excel that indicates a sheet name and an
object reference (a range address or a chart object name) for the copied
object, and a PowerPoint slide number and the position (Left & Top) and size
(Height & Width) of the pasted object, and you may even put the pasted
object's name into the table. The program steps through the list, copying
item A from sheet B and pasting it to slide C, giving it name D as above.

- Jon