paste special from excel to powerpoint

[penfold1992]

im trying to paste a graph keeping original formatting from excel and pasting it into powerpoint.

I have the code:

Powerpoint.Application.ActivePresentation.Slides(CurrSlide).Shapes.PasteSpecial(ppPasteShape, msoFalse)

this works almost EXACTLY but it doesnt keep the original source formatting...
I dont want to paste it in as an object or picture either...

On a slight tangent,
why does

Powerpoint.Application.FileDialog(2)

not work, im trying to bring up a save as window...

thanks again

 

[Rx_]

Please indicate the version of Office.
Have had problems with this level of OLE myself.
Everything in the VBA OLE side seemed to work much better back in 1997.
http://social.msdn.microsoft.com/Fo.../thread/b4b12680-4732-411b-b68f-444655550645/
MS appears to have dropped the ball on office 2010 OLE. They probably want to prepare us for OLE "lite" on the new Cloud version.
This MSDN site might be a better place to find your answer.