I have a somewhat elaborate import scheme for an instrument generated log file. Original structure and file naming are Access Unfriendly. My process involves, copying and renaming a set of 10 files, appending the 10 files a into a single file which is then copied to the import location, undoing a substantial portion of the original formatting, then importing to Access 2010. I have worked out each step individually and tested all steps for functionality. If I run the macro in single-step mode, everything functions as intended, but when I just let it run from start to finish, it skips the append/copy/overwrite function and loads the previously imported file again. The end result is an import that has been "de-formatted" twice and therefore corrupted. All appearances are that the file append/copy function fails to complete before the import kicks in. Is there a way to force/verify completion of one sub before the next runs?
Could a form timer be used to provide breathing room?
What I have tried:
I have tried inserting subs that address other issues along the way, in order to allow time for appending and copying of the target file. I have confirmed the desired result when single stepping through the macro.