P
paulr
I am writing a macro which corrects code in many standard workbooks
using Excel 98 for Mac. I have a loop which deletes all the code from
a module using the deline lines 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 if I edit the procedure at all (e.g. add a comment), the
addfromfile procedure will then work for one additional repetition. Why
does the addfromfile method only work once?
using Excel 98 for Mac. I have a loop which deletes all the code from
a module using the deline lines 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 if I edit the procedure at all (e.g. add a comment), the
addfromfile procedure will then work for one additional repetition. Why
does the addfromfile method only work once?