HI,
I've got a program that scrolls through Excel,grabs the text it needs and the file it belongs on. Then it checks a folder to see if the file exists and if the file name is bad(err.number 53 & err.number 52)if it's good it writes the data else it makes a note and moves on.My problem is it works great for about 3 - 4 bad files at the beggining but as it goes on(35 files total)it doesn't recognize the error flag any more even though I reinitialize it each time it's raised and put doevents all over hell.It's pretty frustrating to get "System error 53;file not found" When my code says on error goto FindOutIfErrorIsNumber_53! where it's supposed to check for it and the error flag isn't even raised! HELP! HELP! HELP! Can some tell me how to force my program to listen to the system!!!