View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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