Excel to Power Point 3

[shadyness]

Hey all,

I have a summary sheet in an Excel 2000 model, which contains three graphs. I would like to program a module that would open up a power point file in the same folder (called export.ppt) and then paste the slides to a particular slide (slide number 4). I have written VBA scripts before that open/print external files using a ShellExecute command, but I don't think this applicable since Power Point is a Microsoft product. Any help or direction would be much appreciated!!

Thanks
<== Some people say they are afraid of heights. With me its table widths. ==>

 

[RobBroekhuis]

Are you sure you want to copy the picture as bitmap? This will increase its size, which may or may not have anything to do with the problem. Try copying as picture instead and see what happens.
Rob

 

[marm75]

The best way that I have found to do this is to copy the range from excel and pastespecial into powerpoint. You can include text graphs and formatting. When you pastespecial I recommend pasting as a picture. Depending on the version on powerpoint that you are using you may have to include the extra step of pasting into word or another instance of excel and then into powerpoint.