It seems that sometimes the operating system keeps the file marked as "in use", accidentally, even after you close it.
See if you can open the file with Excel, and if you can rename it, for instance.
Also, try rebooting the operating system. The above-mentioned circumstance usually gets solved by rebooting.
>I have code in one of my .VCX sub-classes (forms):
>
>FileSrcXls=_DIR_DD_XLS+"dd_mmLoad_data.xls"
>IF FILE(FileSrcXls)
> import from (FileSrcXls) XLS
>
>
>The debugger is stopping on import statement with error message:
>
>OLE error code 0x80030020: A share violation has occurred.
>
>I do NOT have Microsoft Excel open with that worksheet file active.
>Why is this message being thrown, and what can I do to stop it from
>coming up?
>
>DBK
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)