| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing for a directory
Thanks that work just great
"Nigel" wrote: This works for me..... Dim sFolder As String sFolder = "C:\NewFolder" If Dir(sFolder, vbDirectory) = "" Then MkDir sFolder -- Regards, Nigel "MarkS" wrote in message ... Hi, I need to test if a directory exists and if not create it. All I can think of is to use on error and try and open it, they create a new directory if it fails. Any sugestions of a more elegant way |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help to copy files names in a column from one directory to another directory VBA | Excel Programming | |||
| Listing Active Directory groups that have directory access rights | Excel Programming | |||
| Change current directory to the directory that the workbook loads from! | Excel Programming | |||
| Testing if Directory has read/write access | Excel Programming | |||
| Testing for filke in directory | Excel Programming | |||
Threaded Mode
