title: How can I use VBA to find and delete a row of code from module2 (or replace module2) for 200+ files
body: <p>I have line of VBA code in an excel module &quot;Module2&quot; that now causes an error when a user got a new laptop.
  I.T. setup the users profile using their FirstLastName, sensibly, but the users old profile used the &quot;old Machine name&quot;.</p>
  <p><strong>To fix the problem I can edit the VBA code in 200+ files but there must be a better way to do this.</strong></p>
  <p><strong>Or is there code to delete and replace with a corrected module2.</strong></p>
  <p>A batch process of some sort seems to make the most sense.  Is there some code out there I could adapt to do this.  My other option is to ask IT to change the profile back to the old machine name eg &quot;xxxx247&quot; but that may cause problems in the future.</p>
  <p>Regards Peter</p>