[RESOLVED] Excel: Can a file be "in use" without being "Open"

[maurice_whittaker]

I am getting Error 75 Path/File access error, (file in use already I think), when I try to rename it (with coding). I am fairly sure that the file (Workbook) is closed. I read that the error would be number 55 if the file were open. The only person using the computer is me through the VBA program that has caused me so much trouble to date. When my program closes the file it disappears from the Status line as one would expect. I was under the impression that if a W/Book was being used by the master W/Book that it would appear as a "Grouped" file, but it does not appear on the Status line. Do I need to de-activate the file as well as close it? This is somewhat intermittent as the rename is sometimes successful but I haven't quite sorted out when and why. Any suggestions would be gratefully received.