I am writing a macro which corrects code in many standard workbooks. I am working with Excel 98 for Mac. I have a loop which deletes all the code from a module using the deletelines method and then adds the corrected code from a file using the addfromfile method. The loop works correctly with the first workbook but not any subsequent workbooks. I've also noticed that the addfromfile method will work again if I edit the sub in any way (e. g., even add a comment). Why does the addfromfile method only work once?