• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel export selected charts as ppt

Hi friends,

I have a file with few charts. I am trying to export few of the charts from excel to a new powerpoint. I have written the code for this and it is working fine, but few things are there with the code which i am trying to remove. It would be of great help if you can help me in overcoming these obstacles.

- While exporting the charts, powerpoint application becomes active (and it shows the whole process). Is there any way to minimize it and do the export or can we keep excel sheet as active and do the export. I even tries to comment the below code, but it didnt helped me
Code:
  PowerPointApp.Visible = True
  PowerPointApp.Activate

- Can we middle and center align the exported charts in ppt
- is there anyway to shorten the code by looping the export process (but only selected charts need to be exported)

I have also cross posted this at http://www.excelforum.com/excel-pro...xport-selected-charts-as-ppt.html#post4165840

Please find attached the sample file
https://www.dropbox.com/s/khc72hfakvktrb5/Export charts to ppt.xlsm?dl=0

Thanks, Manish
 
Back
Top