Dim FilesToOpen As Variant

FilesToOpen = Application. _
GetOpenFilename("log files (*.log), *.log", 1, "Select any log file", ,
True)

After user selects the (multiple) files, the directory (folder) that
contains those files is "locked" for renaming, deleting etc. (Sharing
violation. source or destination file may be in use.)

Closing the file within Excel doesn't "unlock" the directory. MS Excel
has to be closed.

I have no other lines in the macro. I am using MS Excel 2000 with
Windows 2000.

Please help. Thanks.


---
Message posted from http://www.ExcelForum.com/