Modify VBA with VBA

[MrKowz]

Hey all,

I have read the article by Chip Pearson (http://www.cpearson.com/Excel/vbe.aspx), and I have a question that isn't quite touched on in there.

Is it possible to edit a specific line in a module through a procedure? I am leaving the company I am with at the end of the week, and I am trying to build the most effective way for my employer to continue to use a program I have written (whose code has several areas that is dependent on the naming convention of the workbooks that are opened).

It WOULD be possible for me to go through the code and adapt it for the workbook name through a variable, but I simply don't have time to accomplish this.

Basically, I need to change the following to a specific inputbox value
Module: Sheet1

• Line 9, Col 72 through Line 9, Col 80
• Line 21, Col 57 through Line 21, Col 65
• Line 32, Col 85 through Line 32, Col 93

In each of those line/columns, I am effectively changing the word "Template" to the inputbox value (variable length). I just don't know how to specifically change those lines through VBA.

If I can get a solution to this, I am confident I can build the solution for other modules.

Thanks in advance!

 

[ISY]

Hallo

In the archive I have these links, I have never used the codes
Good Use

http://erlandsendata.no/?cat=25
http://www.cpearson.com/excel/vbe.aspx

 

[xenou]

In any case, I'm not convinced of the usefulness of the line, col editing in code. Too risky in a scripted environment like VBA - one line changes and it's all garbage. Maybe (at least) rewrite the entire module so that you can be sure of the outcome.

BTW - good links. I guess we all know about Chip Pearson's site but didn't realize Erlandsen consulting has some pages on this too.