To be clear, the powerpoint "table" is not meant to be linked. How can I accomplish this programatically? As a user, its very simple to do pastespecial - retain source formatting. This DOES get you an editable, unlinked table in PowerPoint. I have seen this question asked in a few places, and it seems that to get a range of cells into PowerPoint as an editable table you need to use Windows(i).Views.PasteSpecial ppPasteDefault as opposed to Slides(i).Shapes.PasteSpecial ppPasteDefault Now we are starting to migrate to 2010, and lo and behold pastedefault is broken. Needless to say, everything worked fine when we were all running Office 2003. PasteSpecial pptPasteDefault to get a formatted range of cells into powerpoint, while retaining the editability of the range in powerpoint. Ok so I know there are at least a handful of issues when copying-pasting from Excel to PowerPoint when you have different versions of office suite.
0 Comments
Leave a Reply. |