Thanks!
I believe it has been saved. There is a csv file in that path on the server. What's happening is there is live data being fed into the csv file. The macro's job is to save the file every 3 seconds. But these errors pop up and the macro has to be restarted. The errors don't occur all the time either. They are sporadic.
Hello rsford31,
It is a synchronization problem. Only one program at a time can have a file open. The error occurs when you try to close the file to save it and the query is still has the file open. Not really sure how to workaround that other than trapping the error and try again. Probably need to count the number of retries before aborting.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks