Thread: VBA Apllication.run and macros when spreadsheet name changes
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
newguyoldguy newguyoldguy is offline
external usenet poster
  
Posts: 3
Default VBA Apllication.run and macros when spreadsheet name changes
Works great! thank you very much for your help!

"newguyoldguy" wrote:

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.


Reply With QuoteReply With Quote