Error when using IsFileOpen

[bhlabelle]

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.