Macro Help

[Kirby]

I have created numerous macros in an Excel workbook. I have created
the following macro to run all macros at once.

Sub A_Run_CF_Sensitivities()
'
' A_Run_CF_Sensitivities Macro
Application.Run "'Model Kirby version macro.xlsm'!
CF_Copy_Original_Economics"
Application.Run "'Model Kirby version macro.xlsm'!CF_PricePerX"
Application.Run "'Model Kirby version macro.xlsm'!CF_PricePerX"
End Sub

This original workbook will be modified and saved as other workbooks
over time. I assumed that all macros would copy and work independent
of the original workbook. This is no the case. I am having a problem
because the macro above specifies only the macros in the original
workbook.

How can I write this command so that it will copy and run independent
as I copy the workbook as other workbooks? Thank you in advance for
the help.

 

[BobbyJackJoe]

I have created numerous macros in an Excel workbook.  I have created
the following macro to run all macros at once.

Sub A_Run_CF_Sensitivities()
'
' A_Run_CF_Sensitivities Macro
    Application.Run "'Model Kirby version macro.xlsm'!
CF_Copy_Original_Economics"
    Application.Run "'Model Kirby version macro.xlsm'!CF_PricePerX"
    Application.Run "'Model Kirby version macro.xlsm'!CF_PricePerX"
End Sub

This original workbook will be modified and saved as other workbooks
over time.  I assumed that all macros would copy and work independent
of the original workbook.  This is no the case.  I am having a problem
because the macro above specifies only the macros in the original
workbook.

How can I write this command so that it will copy and run independent
as I copy the workbook as other workbooks?  Thank you in advance for
the help.

There is no good solution to this problem. Best bet would be to hire a
consultant to figure this one out. Good luck.