Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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