View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Simon Shaw Simon Shaw is offline
external usenet poster
 
Posts: 60
Default 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