CODEWITHSUNDEEP
vbachartspowerpoint
Jason Stallard
Jason Stallard

Reputation: 348

Copy charts from Excel to PowerPoint using VBA

I have a slide deck that changes it's name daily. The source data is in several statically named Excel 2013 worksheets. It would be neater to run a macro from the PPTM but all the examples I have found for copying charts is from the XLSM side. Is there a PowerPoint 2013 equivalent of PowerPoint.Application? Dim sourceXL As excel.Application gives Run-time error '424': Oject required as Excel is not recognised whereas .Application is.

Upvotes: 0

Views: 64

Answers (1)

Jon Peltier
Jon Peltier

Reputation: 6063

Have you set a reference to Excel? In the VBE, go to the Tools menu > References, scroll down to Microsoft Excel, and check the box.

Upvotes: 1

Related Questions