| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Apllication.run and macros when spreadsheet name changes
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to save spreadsheet with macros??????? | Excel Discussion (Misc queries) | |||
| How can I complete a spreadsheet using macros? | Excel Worksheet Functions | |||
| How can I complete a spreadsheet using macros? | Excel Discussion (Misc queries) | |||
| Copying a spreadsheet with macros | Excel Worksheet Functions | |||
| Apllication.OnTime | Excel Programming | |||
Threaded Mode
