Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.FileDialog(msoFileDialogOpen) and 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? -- H.A. de Wilde ------------------------------------------------------------------------ H.A. de Wilde's Profile: http://www.excelforum.com/member.php...o&userid=30679 View this thread: http://www.excelforum.com/showthread...hreadid=552051 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.FileDialog(msoFileDialogOpen) and 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/ -- mudraker ------------------------------------------------------------------------ mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473 View this thread: http://www.excelforum.com/showthread...hreadid=552051 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.FileDialog(msoFileDialogOpen) and error 75
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 -- H.A. de Wilde ------------------------------------------------------------------------ H.A. de Wilde's Profile: http://www.excelforum.com/member.php...o&userid=30679 View this thread: http://www.excelforum.com/showthread...hreadid=552051 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.FileDialog(msoFileDialogOpen) and error 75
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 -- mudraker ------------------------------------------------------------------------ mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473 View this thread: http://www.excelforum.com/showthread...hreadid=552051 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Application.FileDialog(msoFileDialogFolderPicker) | Excel Discussion (Misc queries) | |||
Application.FileDialog(msoFileDialogOpen) | Excel Programming | |||
FileDialog(msoFileDialogOpen) | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Alternative to Application.FileDialog (please)? | Excel Programming |