+ Reply to Thread
Results 1 to 5 of 5

Remove Error when copy Excel pie chart to power point

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Remove Error when copy Excel pie chart to power point

    Hi,

    I have created a macro to copy Excel Pie Chart to Powerpoint. unfortunately, there is error message once the PowerPoint Application is closed.


    "
    "
    "
         ws.ChartObjects("Chart 1").Activate
         ActiveChart.PlotArea.Select
         ActiveChart.ChartArea.Copy
    
         Set myShapeRange = mySlide.Shapes.PasteSpecial(ppPasteDefault)
    
            With myShapeRange
                .Left = 525
                .Top = 65
                .Width = 175
                .Height = 140
                .Name = "Pie Chart"
            End With
    
          mySlide.Shapes("Pie Chart").Line.Visible = msoFalse
    "
    "
    "
    PPointApp.ActivePresentation.SaveAs fname, 1
    PPointApp.ActivePresentation.Close
    Set PPointApp = Nothing
    Appreciate your help to resolve the problem

    error.jpg

    here is my workbook.
    Attached Files Attached Files
    Last edited by Faridwahidi; 07-06-2015 at 08:53 PM.

  2. #2
    Forum Contributor
    Join Date
    07-07-2014
    Location
    ericbartha.com
    MS-Off Ver
    2016 Professional
    Posts
    126

    Re: Remove Error when copy Excel pie chart to power point

    Does the the macro work except for the error?

    If so, try putting
    Application.DisplayAlerts = False
    at the very begining. Just be sure to switch it back to true at the very end.

    Edit: I wasn't paying attention and typed the wrong funtion. Try the updated one.
    Last edited by ericbartha; 07-06-2015 at 02:00 PM. Reason: Updated with correct funtion

  3. #3
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Remove Error when copy Excel pie chart to power point

    Hi ericbarta,

    The macro works except for the error message.

    I have already tested with Application.DisplayAlert or ScreenUdating. both seems does not work to remove the error message.

  4. #4
    Registered User
    Join Date
    04-09-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2010
    Posts
    66

    Re: Remove Error when copy Excel pie chart to power point

    First of all, Run PowerPoint in safe mode and follow these steps:

    1. Click on File Tab
    2. Go to Option->Add-Ins
    3. On the Manage menu, select COM Add-Ins
    4. Disable the COM Add-Ins if it is available in the list.
    5. Now normally open the PowerPoint File.

    I hope it will help you.

  5. #5
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Remove Error when copy Excel pie chart to power point

    Hi Steve,

    I have opened in safe mode but I found no item COM Add-Ins. So, there is nothing to be disabled. The stupid error/bugs make my life in trouble.

    did you download my attachment and run at your end? would you get the same thing?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Resize copied Chart from Excel to Power Point
    By LPrenici in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2014, 08:54 AM
  2. Copy graph from Excel to Power Point & update it automatically
    By zuppi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-06-2012, 10:19 AM
  3. Power Point Chart linked to Excel Chart
    By pr4t3ek in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 09-24-2009, 11:33 AM
  4. copy data from excel to power point
    By iscar_marius in forum Excel General
    Replies: 8
    Last Post: 02-09-2009, 08:20 AM
  5. Copy multiple charts from Excel to Power Point
    By Genef in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-01-2005, 10:07 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1