Hi everyone, I have what I think may be a simple question. I currently have a macro written in excel. What I am trying to do is open the excel file if it is not already open, and then run the excel macro all from powerpoint vba. I think I have the opening of the file correct, but can not figure out the syntax in powerpoint vba to call an excel macro. Can anyone please help? This is what I have so far, and it does not work with "xlApp.Run Macro1"
Sub exportToExcel()

Dim xlApp As Object
Dim xlWorkBook As Object

Set xlApp = CreateObject("Excel.Application")

xlApp.Visible = True
Set xlWorkBook = xlApp.Workbooks.Open("C:\Users\NA54994\Documents\My Received Files\Test.xlsm", True, False)
xlApp.Run Macro1

Set xlApp = Nothing
Set xlWorkBook = Nothing

 End Sub