Consulting

Results 1 to 1 of 1

Thread: VBA copy pasting crosstab - wrong letters

  1. #1
    VBAX Newbie
    Joined
    Apr 2020
    Posts
    1
    Location

    VBA copy pasting crosstab - wrong letters

    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
    Last edited by Bob Phillips; 04-30-2020 at 01:58 AM. Reason: Added code tags

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •