Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a folder
Sub test()
' I want to creat a folder if that folder doesn't exist in the path. ' The following statement is not supported. What is the right way?, Please. If Not Application.exist("I:\Mybackup\") Then MkDir ("I:\Mybackup\") End Sub |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a folder
One way:
Sub addFolder() Dim pth As String pth = "I:\Mybackup\" If Dir(pth, vbDirectory) = "" Then MkDir pth Else MsgBox "exists" End If End Sub Another way: On Error Resume Next MkDir "I:\Mybackup\" On Error GoTo0 I personally prefer the first way. dan wrote: Sub test() ' I want to creat a folder if that folder doesn't exist in the path. ' The following statement is not supported. What is the right way?, Please. If Not Application.exist("I:\Mybackup\") Then MkDir ("I:\Mybackup\") End Sub |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a folder
Use Dir
Sub test() ' I want to creat a folder if that folder doesn't exist in the path. ' The following statement is not supported. What is the right way?, Please. If Dir("C:\Mybackup\") = "" Then MkDir ("C:\temp\Mybackup\") End If End Sub "dan" wrote: Sub test() ' I want to creat a folder if that folder doesn't exist in the path. ' The following statement is not supported. What is the right way?, Please. If Not Application.exist("I:\Mybackup\") Then MkDir ("I:\Mybackup\") End Sub |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a folder
Thank you very much, JW
"JW" wrote in message oups.com... One way: Sub addFolder() Dim pth As String pth = "I:\Mybackup\" If Dir(pth, vbDirectory) = "" Then MkDir pth Else MsgBox "exists" End If End Sub Another way: On Error Resume Next MkDir "I:\Mybackup\" On Error GoTo0 I personally prefer the first way. dan wrote: Sub test() ' I want to creat a folder if that folder doesn't exist in the path. ' The following statement is not supported. What is the right way?, Please. If Not Application.exist("I:\Mybackup\") Then MkDir ("I:\Mybackup\") End Sub |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a folder
Hi Joel,
I like your simple statement. Thank you very much. "Joel" wrote in message ... Use Dir Sub test() ' I want to creat a folder if that folder doesn't exist in the path. ' The following statement is not supported. What is the right way?, Please. If Dir("C:\Mybackup\") = "" Then MkDir ("C:\temp\Mybackup\") End If End Sub "dan" wrote: Sub test() ' I want to creat a folder if that folder doesn't exist in the path. ' The following statement is not supported. What is the right way?, Please. If Not Application.exist("I:\Mybackup\") Then MkDir ("I:\Mybackup\") End Sub |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a folder
Maybe you can just ignore the error if the folder already exists:
on error resume next mkdir "I:\mybackup" on error goto 0 dan wrote: Sub test() ' I want to creat a folder if that folder doesn't exist in the path. ' The following statement is not supported. What is the right way?, Please. If Not Application.exist("I:\Mybackup\") Then MkDir ("I:\Mybackup\") End Sub -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a new folder that does not already exsit. | Excel Discussion (Misc queries) | |||
Creating a List of the files in a folder in excel | Excel Discussion (Misc queries) | |||
How to decide folder-depth or How to select more folders/subfolders (folder-tree) ? | Excel Discussion (Misc queries) | |||
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) | |||
creating an XLS file from " files" data in a Folder | Excel Discussion (Misc queries) |