Anyone had figured out PasteSpecial

[paul]

Hi everyone. Just trying to adapt our app to office 2007, had this piece of
code that worked with all previous versions:

_shape = pptSlide.Shapes.PasteSpecial(10)

There is an excel table on the clip board and this is just pasting it onto a
power point slide as a ppPasteOLEObject. How would one achieve the same
results with office 2007?

Thanks in advance

 

[paul]

Hi Steve, thanks for your reply. Unfortunately this is not VBA but
vb.net(.net framework 1.x). This used to work like a charm. End result is a
Power Point slide with embeded Excel worksheet. Too bad that does not work
with 2007. I get "Clipboard is empty or can't paste this here". Clipboard
is not empty. Using PasteSpecial(2) /* i think */ I can drop it down as an
image, but emeded worksheet, which is what I need does not happen for some
reason. I guess I have to keep on looking. Can anyone point to a page
containing the whole enumeration for PasteSpecial under thisnew version of
office?

Thanks

Paul

 

[paul]

Thanks Steve, I spend about 1 1/2 hours looking for a menu item launching the
IDE in PPT, but I guess the only way to do this now is Alt+F11. I will give
it another try I guess and then I can go to my boss and ask for a whole team
to be assigned to this project.

I have been involved with this app for quite some time. New versions of
office (XP, 2003) were an easy fix for us and usually would involve
overriding couple of functions. This time around, it seems that we have to
re-do all our office interaction and considering that this is pretty much all
our app does, this means lots of work. I am not even going to mention Vista
at this point.

I guess many developers are very busy now.

Thanks for your help