vba code to change vba code

[alexaronson]

Hello and thanks for looking at my question.

I have a master work sheet with code that defines the workbook. For instance, I have

Dim masterWB as Workbook

Set masterWB = Workbooks("BLAH.xlsm")

My master workbook now needs to have various versions made so that I now have "Blah1.xlsm", "Blah2.xlsm", etc.

How can I run a macro that would change all the macro's within "Blah1.xlsm" so that Set masterWB = Workbooks("BLAH.xlsm") now = "Blah1.xlsm"

Thanks

 

[Andrew Poulsom]

If the code is in that workbook you can use:

Set masterWB = ThisWorkbook

 

[MrKowz]

Try a FIND/REPLACE and have it look at the project.

 

[VoG]

This may help http://www.cpearson.com/excel/VBE.aspx