Run an Excel Macro From PowerPoint VBA

[bricksandivy14]

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.

[6StringJazzer]

I have not tested this but I think this will do it:

Please Login or Register  to view this content.

[6StringJazzer]

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

Please Login or Register  to view this content.

[bricksandivy14]

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!

[bricksandivy14]

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?

[Andy Pope]

In that code Macro1 is a variable, rather than the name of the macro to be run.
Either assign the macro name to the variable or better yet include Macro1 in the text

Please Login or Register  to view this content.