Hello All,
I'm running into a bit of an issue, where I have a table of data that contains a minichart. I'm using the a macro with the ".CopyBitmapToClipboard" method to export various charts and tables to a power-point presentation dynamically. However, when I export via the macro the minicharts are blank. I've tried adding in delays and "wait for idles" at various points in the macro's loop but they don't seem to help. If I "Right-click -> Copy to Clipboard -> Image" and manually paste the minichart is populated.
Here is the relevant code:
ActiveDocument.GetSheetObject("TXT_TITLE").CopyBitmapToClipboard
PPSlide.Shapes.Paste
PPSlide.Shapes(PPSlide.Shapes.Count).LockAspectRatio=msoTrue
PPSlide.Shapes(PPSlide.Shapes.Count).Top = 40
PPSlide.Shapes(PPSlide.Shapes.Count).Left = 30
