KB0107: How can I copy-paste thinkcell charts in my VBA Code?

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

Solution

You cannot copy-paste individual thinkcell elements using macros.

Instead, copy-paste the entire PowerPoint slide that contains the thinkcell element. By copying the slide, thinkcell functionality is preserved even if the thinkcell add-in is not currently present in PowerPoint.

Explanation

When you manually copy-paste a chart, thinkcell 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 thinkcell'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 thinkcell?