| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check directory permissions
Okay. Thank you.
On Mar 23, 10:54 am, Dave Peterson wrote: Then I'd test it with a testfile. Dave T wrote: When the initial dialogue that let's them select their output directory comes up I'd like it to warn them immedeately if they picked a directory that they shouldn't have. The script is producing a few hundred little text files, and I'd like it to be more "fire-and-forget". So if there is something quick and easy, I'd rather do that at the start than have to trap an error and force the user to pay attention after the setup. On Mar 22, 6:48 pm, Dave Peterson wrote: Why not just check for an error after they (try to) save the file--why bother with the test file? Dave T wrote: I've got a little script which needs to put it's output in a user- specified directory and I'd like to make sure that the user has permission to write to the directory before letting the script try. I've seen some posts which suggest trying to write a file to the directory first, while other suggested using GetAtrr(). GetAtrr() only seems to want to tell me that the specified directory is in fact a directory. Is there a simple way to check that the user has write permissions or am I better off try to write a file and trapping that error? -- Dave Peterson -- Dave Peterson- Hide quoted text - - Show quoted text - |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking for File/Directory Permissions | Excel Programming | |||
| Check a file in a directory | Excel Programming | |||
| How to check if a folder/directory exist using VBA | Excel Programming | |||
| How to check if the directory exists? | Excel Programming | |||
| Check if directory empty OR no of files in directory. | Excel Programming | |||
![Dave T[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
