Editing VB Code with VB
What sort of modification do you want to do? Add event code, add a macro,
delete either, add a whole module?
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Simon Shaw" <simonATsimonstoolsDOTcom wrote in message
...
i am trying to write VBA to patch as series of worksheets I created and
deployed. problem is, I need to slightly modify code in a VBA module in
each
file. so I need to edit existing VBA in the worksheets using a VBA.
does anyone have an example of how to do this... I just need to see the
code
for modifing the VBA in the module. I can write the rest for looping
through
open workbooks, etc.
Thanks
simon shaw
|