Edit excel macro programatically

[epymsam]

I have created an excel macro in a workbook. What I need to do is edit the excel macro from another excel worksheet. IE do a find and replace on the macro code in the other sheet. I cannot replace the current sheet as it contains important data. This excel sheet is widely deployed and so Ideally I want to write a macro which opens the sheet, edits the code and then saves it. Any ideas?

 

[paelinck]

Dynamically editing a VBA program (or any kind of program) sounds like bad programming practice and in my opinion should be avoided. Is there no way your problem could be solved by using variables, constants or extra arguments in your function(s)? Or maybe by adding a worksheet that contains the desired settings to your workbook. You might also consider storing the settings in a separate workbook or in a text file that could be read by your macro.

I hope this will help you find a solution to your problem.

Marc