Macro to run macros

[Guest]

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

 

[Bob Phillips]

You will need some way of working out what the name is, and we can't tell
you that, you will need to tell us.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Is an InputBox() for the file name not a solution?

 

[Guest]

I found the answer:

ThisWorkbook.Application.Run (["VOLUME"])

This runs the macro "VOLUME" no matter what the file name.

Thanks for your suggestions. The last time I posted a question I got major
help.