Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Exporting a SmartArt graphic

  1. #1
    Board Regular
    Join Date
    May 2004
    Posts
    342
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Exporting a SmartArt graphic

    I dynamically generate Org Charts using the SmartArt CirclePictureHierarchy object, but I am unable to export them as PDF files in code.
    I thought I could use the same code as I use to export a Chart, but that didn't work.
    I believe exporting Shapes is doable, but I can't capture the code in a macro when I select Design->Convert to Shapes.

  2. #2
    MrExcel MVP
    Join Date
    Mar 2004
    Location
    Canada
    Posts
    18,036
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Exporting a SmartArt graphic

    The SmartArt is a shape, so you can copy the shape like this...

    Code:
    activesheet.shapes("Diagram 1").CopyPicture
    Then you can paste the picture into your chart so that it can be exported. Change the name of the shape accordingly.

    Hope this helps!
    Last edited by Domenic; Jul 13th, 2018 at 10:25 AM.

  3. #3
    Board Regular
    Join Date
    May 2004
    Posts
    342
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Exporting a SmartArt graphic

    Thanks! Also the chart initially contained data so I needed to empty it out with
    Code:
    ActiveChart.ChartArea.Clear

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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