You can call a macro from an open workbook using....

Call Midmonthnumbersmove


--
Cheers
Nigel



"newguyoldguy" wrote in message
...
How can change the following statement to run a macro so I do not have to
change the spreadsheet name every time it changes.

Application.Run "'Salesman pay 2.9.xls'!Midmonthnumbersmove"

'Salesman pay 2.9.xls' is the spreadsheet name in this example. I would
just like the statement to run the macro Midmonthnumbersmove no matter
what
the spreadsheet name is.