Editing VB Code with VB

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

Hi Simon,

See Chip Pearson's VBE programming page at:

http://www.cpearson.com/excel/vbe.htm


---
Regards,
Norman



"Simon Shaw" <simonATsimonstoolsDOTcom> wrote in message
news:3B303508-F3C1-47D7-B99D-E5DEEE9DDDF8@microsoft.com...
>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

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
news:3B303508-F3C1-47D7-B99D-E5DEEE9DDDF8@microsoft.com...
> 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