every time I try to rename a folder (name xxx as yyy) error 75 occurs if the folder was opened before with Application.FileDialog(msoFileDialogOpen). It seems that there is a lock during the whole Excel-session. Is there away to avoid this error 75?
every time I try to rename a folder (name xxx as yyy) error 75 occurs if the folder was opened before with Application.FileDialog(msoFileDialogOpen). It seems that there is a lock during the whole Excel-session. Is there away to avoid this error 75?
I have had similar experience with other programs as well as Excel
I now use Unlocker 1.8.3.exe
Unlocker is free ware and available from many web sites. Here is one of them
http://ccollomb.free.fr/unlocker/
Dear Mudraker,
thanks for your reply.
Now I found out that the folder that was last accessed with the FileDialog, is set by Windows as the Current Directory. And it seems that renaming the Current Directory is not allowed.
When I change the Current Directory (ChDir left(CurDir,3)) then I can rename my folder.
Maybe this is also a solution for the cases you encountered problems with renaming a folder that was last accessed before with the FileDilog.
Kind regards,
hugo de wilde
hugo
I was not aware of the exact cause of the problem. Unlocker did tell me that Excel had the folder of file locked.
As this usually occurs when I run a macro I will now change the macro code to change folders at the end.
Thanks for the feed back
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks