Manish Sharma
Member
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
- 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
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