Code that edits your code

[Guest]

Just a curious question... I was wondering if anybody knows how to write
code that would modify the code you use behind forms. For instance, I have a
databse that logs field changes to revision history table, and all the
related variables I prefixed with 'rev'. Now that I have the thing up and
running good, I'd like to get rid of some of the junk characters and clean up
my variable names. Ideally, code such as 'if the prefix is "rev" change it
to "r".

If this is an easy thing to do, that would be great, but if there is a way
and it's a real pain to get right, I'm probably not going to play with it
much. Just wondering... thanks!

 

[Rob Parker]

MZTools is an add-in (free) to extend VBA editing: its global search/replace
will let you do this easily. Check it out, at
http://www.mztools.com/v3/mztools3.aspx

And there's lots of other nice things it does - I wouldn't like to be
without it.

HTH,

Rob

 

[Guest]

Looks great, I'll have to try that out. Thanks

MZTools is an add-in (free) to extend VBA editing: its global search/replace
will let you do this easily. Check it out, at
http://www.mztools.com/v3/mztools3.aspx

And there's lots of other nice things it does - I wouldn't like to be
without it.

HTH,

Rob