Macro to run macros
I am setting up a macro to run other macros in the spreadsheet.
ThisWorkbook.Application.Run "IP8V00.xls!VOLUME"
There are many other similar lines running other macros in the spreadsheet.
I need to send this spreadsheet out to other users each with their own
spreadsheet name. Is there a way so that the macro "VOLUME" will run no
matter what the spreadsheet name. The other users will not have IP8V00.xls
available to them
|