StillUsingNotes
New Member
- Joined
- May 4, 2010
- Messages
- 13
By "atomic" I mean, the thing that a DBMS does with the keywords like "begin transaction", "commit", and "rollback". Either all the changes made are OK, or, all the changes would be reversed after an error.
i ask because I have a macro that sometimes works, and sometimes not. When it fails, i can watch it making changes (in a loop over many rows), then it stops, and all the changes are gone - the data is the way it was before the macro ran.
The macro itself has nothing in it to reverse changes.
I think it is failing in an attempt to Sort.
So far I have not seen any error messages, but it is invoked from a program which saves the workbook, then moves on to the next workbook (all via OLE automation). So nothing is displayed for very long.
i ask because I have a macro that sometimes works, and sometimes not. When it fails, i can watch it making changes (in a loop over many rows), then it stops, and all the changes are gone - the data is the way it was before the macro ran.
The macro itself has nothing in it to reverse changes.
I think it is failing in an attempt to Sort.
So far I have not seen any error messages, but it is invoked from a program which saves the workbook, then moves on to the next workbook (all via OLE automation). So nothing is displayed for very long.
