How to put a Prism object into Word or PowerPoint or Excel via scripting.

There is no Prism script to send a graph (or layout) to Word or PowerPoint. There are script commands to export in various formats, but if you put these into Word or PowerPoint, they will be pictures that cannot be edited. 

If you want to use a script to send a Prism object to Word or PowerPoint, do the following. 

Within Prism, use the Copy script command to put the graph (or layout) on the clipboard. 

Within the VBA macro, use the ActiveSheet.Paste command to paste the full Prism object. That means that someone can double-click on that graph to open Prism for editing.

If you have trouble getting the OLE object, rather than a picture, to paste, try this more complete command:

ActiveSheet.PasteSpecial DataType:=ppPasteOLEObject

Note: This page simply passes along some information we learned from a Prism customer. No one at GraphPad has experience with VBA, so we are unable to offer much help.