Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Directory "Locked" when selecting multiple files using GetOpenFilename
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Directory "Locked" when selecting multiple files using GetOpenFilename
This is because GetOpenFilename makes the selected directory the current directory. Add something like ChDir "C:\" and the originally selected directory should be unlocked. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "esbey " wrote in message ... 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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table Report Filter - "OR" instead of "AND" Multiple Filters | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
freeze window creates multiple "views" suffixed with ":n" | Excel Discussion (Misc queries) |