if this is the active workbook, you don't need the spreadsheet name. is this
in some other workbook?

--


Gary


"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.