View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
derrick derrick is offline
external usenet poster
 
Posts: 1
Default Change A Line in A Module Using VBA Code

Hi,

I have about a 100 workbooks all with the same VBA code in them. I
need to change a line in the VBA code in each of them and would like
to use code rather than opening each of the workbooks and changing it.

Can this be done? I just need the code to reference the line and make
the change - I have the code to open each workbook and close it
already in a directory.

Thanks,
Derrick