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

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)

"msdrolf" wrote in message
...
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

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

"msdrolf" wrote:

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

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.