Copy Chart to Powerpoint Macro

0

Hi guys n girls

I create a number of charts in xls workbooks that are used in PowerPoint reports on a weekly basis. One workbook per PPT report. The charts are always the same (data is updated, and a narrative is updated), these then replace/update the corresponding chart in PPT, placement/order does not change. Currently I use copy and Paste but would like to automate the process via a macro. Does anyone know of an existing macro that would point me in the right direction?

Please note that I'm a novice with macros but keen to learn

Answer
Discuss

Answers

0

If you google something like "Export Excel tables to PoswerPoint" you willl find lots of suggestions. Here is one. That will get you started. Come back for more help here after you have found a beginning.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login