control
04-30-2020, 01:13 AM
When creating PPT presentation from Excel using VBA, special characteristics are not shown correctly in PPT. When crosstab is copy pasted manually from Excel to PPT, the special characteristic is shown correctly.
Example: București -> Bucurest?i
I'm using this VBA:
'CopyPicture Excel Range
rng.Copy
rng.CopyPicture
'Paste to PowerPoint and position
PPT_biannual.Activate
activeSlide.Shapes.PasteSpecial(DataType:=ppPasteMetafilePicture).Select
Example: București -> Bucurest?i
I'm using this VBA:
'CopyPicture Excel Range
rng.Copy
rng.CopyPicture
'Paste to PowerPoint and position
PPT_biannual.Activate
activeSlide.Shapes.PasteSpecial(DataType:=ppPasteMetafilePicture).Select