Run an Excel Macro From PowerPoint VBA

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"

Please Login or Register  to view this content.

If the files are not in the same folder then you may need:

Please Login or Register  to view this content.

Originally Posted by 6StringJazzer

If the files are not in the same folder then you may need:

Please Login or Register  to view this content.

Thank you I will try this on Monday and let you know if it works or not!

Originally Posted by 6StringJazzer

If the files are not in the same folder then you may need:

Please Login or Register  to view this content.

Hi thank you again for the reply. I tried both the fullname and name on that line of code, and I am receiving an error. "Run time error '1004': Cannot run the macro "C:\Users\NA54994\Documents\My Received Files\Test.xlsm'!'. The macro may not be available in this workbook or all macros may be disabled"

Macros are enabled and the macro is showing in the developer tab. Any thoughts on how to fix this?