Exporting a chart to PPT by clicking a button

**dreams** · 06-09-2010, 05:10 AM

Hi Expert,

i have created some reports with some graphs and will like to create a button which by clicking on it export the graph into PPT.

How to create such a button or function?

Thank you in advance for your input.

Cheers

Gilo

**Andy Pope** · 06-10-2010, 04:05 AM

Have a look at
http://peltiertech.com/Excel/XL_PPT.html

**dreams** · 06-24-2010, 06:24 AM

Hello Andy,,
thank you for your input.
I used the code by adding a button unfortunatelly it is working partially.
When i click on the button but by clicking on run in the macro, it is copying the Graph in the ppt.
Hier is the code:

Please Login or Register  to view this content.

What i am doing wrong?

Thank you.

Cheers

Gilo

**Andy Pope** · 06-24-2010, 06:30 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

If you want the code to run when you click a button then you need to call the routine from the click event.

Please Login or Register  to view this content.

**teylyn** · 06-24-2010, 06:53 AM

Gilo, bitte! Du bist seit 'ner Ewigkeit hier registriert und solltest die Regeln kennen!

**dreams** · 06-24-2010, 08:58 AM

Hi Andy,

thank you for the response. i followed your instructions but it still not working.
Once click on the button there is a message asking to select the chart and to retry again.
I did it but it still not working.

Thanks

Cheers

Gilo

**Andy Pope** · 06-24-2010, 09:45 AM

The problem is the routine is suppose to run on the active chart and by pressing a button you have removed focus from the chart so there is no active chart.

If the button is from the Control Toolbox set the property TackFocusOnClick to False.

Or use a Forms Button and assign the macro to the button.