Knowledge base KB0107
  2. Resources
  3. Knowledge base
  4. KB0107

How can I copy-paste think-cell charts in my VBA Code?

Solution

You cannot copy-paste individual think-cell elements using macros.
Instead, copy-paste the entire PowerPoint slide that contains the think-cell element. By copying the slide, think-cell functionality is preserved even if the think-cell add-in is not currently present in PowerPoint.

Explanation

When you manually copy-paste a chart, think-cell intercepts the user interaction (i.e., pressing the  Ctrl + C keyboard shortcut or clicking the PowerPoint menu item) and does some additional work to maintain its metadata. Copy-paste calls in your macro cannot be intercepted and therefore think-cell's metadata does not get copied along.

You may also be interested in KB0073: How to find out with VBA if a shape is used by think-cell?

Share