What is wrong with this picture?
I am copy/pasting data and pictures from Excel into PowerPoint.
First macro in Excel copies graphs and pastes into a PowerPoint Presentation. It also starts a PowerPoint macro. That works fine.
From there, I need the PowerPoint macro to return to the Excel window and run the second Excel macro.
In PowerPoint I have:
Dim XL As Object
Set XL = CreateObject("Excel.Application"
XL.Run "C:\test.xls!Module1.CopyData"
I am needing to toggle a few times between Powerpoint and Excel, but any time I add additional code (application.quit, etc.), to the above code, it gives me an application.run error. As soon as I remove any code below it, it works fine.
Thanks in advance!
I am copy/pasting data and pictures from Excel into PowerPoint.
First macro in Excel copies graphs and pastes into a PowerPoint Presentation. It also starts a PowerPoint macro. That works fine.
From there, I need the PowerPoint macro to return to the Excel window and run the second Excel macro.
In PowerPoint I have:
Dim XL As Object
Set XL = CreateObject("Excel.Application"
XL.Run "C:\test.xls!Module1.CopyData"
I am needing to toggle a few times between Powerpoint and Excel, but any time I add additional code (application.quit, etc.), to the above code, it gives me an application.run error. As soon as I remove any code below it, it works fine.
Thanks in advance!