Edit excel macro programatically

epymsam · Mar 25th, 2002, 04:40 AM

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 · Mar 25th, 2002, 05:31 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 04:40 AM	#1
epymsam New Member Join Date: Mar 2002 Posts: 2	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?

Mar 25th, 2002, 05:31 AM	#2
paelinck Board Regular Join Date: Mar 2002 Location: Leiden, The Netherlands Posts: 68	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