CODEWITHSUNDEEP
vbapowerpointpaste
midaym
midaym

Reputation: 83

vba command to paste special KeepSourceFormatting(K) in powerPoint

i am trying to take a cell range from excel and copy it to powerpoint2010. However I do not want to use the Embedded format but rather the KeepSourceFormatting one. I tried the following command

ActiveWindow.View.PasteSpecial DataType:=ppPasteOLEObject, Link:=msoFalse

but this still creates an object that launches excel to edit the contents.

basically I want to paste a table of formated data from excel to powerpoint and maintain its appearance but still be able to edit the contents in powerpoint.

any ideas?

Upvotes: 0

Views: 1436

Answers (1)

Kazimierz Jawor
Kazimierz Jawor

Reputation: 19087

There are following options for DataType:

ppPasteEnhancedMetafile which allows edition each of separate field of the table (rather pure solution)

ppPasteMetafilePicture similar option

ppPasteOLEObjectwhich you know

I can't see any other option.

Upvotes: 1

Related Questions