I've tried many variations of IsFileOpen and I always get an error at the point in the code when Excel tries to open a spreadsheet that is alreay open. The current code I have for the problem line is:Open strFullPathFileName For Random Access Read Write Lock Read Write As lngFile
I get a permission denied error, and I have to end the process. Any ideas? I'm kind of a beginner at this!
Thanks.
