View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
msdrolf msdrolf is offline
external usenet poster
 
Posts: 19
Default 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