welly_music
New Member
- Joined
- Jul 21, 2010
- Messages
- 5
Hi there.
I have recorded a large macro to automate a few things ain a spreadsheet, and in this I have run a macro in the same workbook a number of times as follows :
Application.Run _
"myfilename.xlsm'!Calculate_residual"
When I save an iteration of this spreadsheet (it is a working property model), the code still points to the original document........ is there any way of removing this "myfilename.xlsm' reference so that the macro refers to the Calculate_residual macro in the saved iteration (ie current document) instead of the old version of the model where the macro was first recorded?
Thanks!
I have recorded a large macro to automate a few things ain a spreadsheet, and in this I have run a macro in the same workbook a number of times as follows :
Application.Run _
"myfilename.xlsm'!Calculate_residual"
When I save an iteration of this spreadsheet (it is a working property model), the code still points to the original document........ is there any way of removing this "myfilename.xlsm' reference so that the macro refers to the Calculate_residual macro in the saved iteration (ie current document) instead of the old version of the model where the macro was first recorded?
Thanks!