Application.FileDialog(msoFileDialogOpen) and error 75

[H.A. de Wilde]

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?

 

[mudraker]

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/

 

[H.A. de Wilde]

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

 

[mudraker]

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