Run Macro from VBA

[jbowes99]

How do I run a MACRO from a VBA script (from a button)??

Thanks,


- Jeff

 

[suprmatt]

Unfortunately that doesn't work. I get a "Compile error: Expected: end of statement" when I try that.

Have you tried:

Application.Run "" & Sheetname & "!" & Macroname & ""

 

[dG4Ever]

Unfortunately that doesn't work. I get a "Compile error: Expected: end of statement" when I try that.

I think you got this error because your sheetname contains some spaces. Maybe you should try this expression :

Application.Run "'" & Sheetname & "'!" & Macroname

 

[suprmatt]

I think you got this error because your sheetname contains some spaces. Maybe you should try this expression :

Application.Run "'" & Sheetname & "'!" & Macroname

The correct syntax for the Application.Run statement is:

Application.Run ("" & Sheetname & "!" & Macroname & "")

You need to close the quotes after the Macroname variable, other wise Excel reads the expected end of the statement as the "!"

However the variable Sheetname needs to refer to the workbook, not the worksheet.

 

[CRUTHERFORD]

you should be able to just do the following

Call Macro1

Change Macro1 to be the name you gave the macro