Results 1 to 2 of 2

Thread: Ghost files

  1. #1
    Silver Lounger
    Join Date
    Jul 2001
    Ottawa, Ontario, Canada
    Thanked 1 Time in 1 Post

    Ghost files

    This problem has been a minor irritant to me for some time, but it's no longer minor.
    Frequently when:
    1. <LI>opening a file in Excel or Word from folder A , then
      <LI>saving that file to folder B (using the SaveAs command), then
      <LI>deleting all files in folder A, and finally
      <LI>attempting to delete folder A
    I receive a warning that, "The folder cannot be deleted; there has been a sharing violation. The source or destination files may be in use."

    <UL><LI>I can see no files in folder A, and; yes the folder options are set to show hidden files.
    <LI>closing the file does not cure the problem
    <LI>closing the application does allow me to delete the folder.[/list]Since I am trying to do this in Excel VBA closing the application is not an option.
    If anyone can provide insight or a workaround, it would be much appreciated.

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Tallahassee, Florida, USA
    Thanked 0 Times in 0 Posts

    Re: Ghost files

    Hi, Don. Is it possible that the Office app still has its hooks into the WinExplorer via File/Open? I have seen this behavior often, but now have only WinXP or 03 OS so can't test or confirm my theory. To test it, after you've done step 2, before going to 3 use the app's File / Open procedure -- is it still pointing to Folder A? If so, maybe a hidden window in the app which redirects it to Folder B to open a file and close it without editing and then proceeding to your step 3. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts