| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does folder exist problem
My Code below is attempting to check if a folder exists and if so exit the
sub. Can anyone point me in the right direction mypath = "e:\Temp\" & Actuals If Dir(mypath) < "" Then MkDir mypath Else MsgBox "Folder already Exists" Exit Sub End If For i = lb To ub mypath = "e:\Temp\" & Actuals & Arr1(i) If Dir(mypath) = "" Then MkDir mypath End If Next i |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Outlook problem ("no custom dictionary exist") | Excel Discussion (Misc queries) | |||
| Excel VBA - Copy Folder problem | Excel Programming | |||
| How to: check if folder exist, if not, create | Excel Programming | |||
| Excel VBA - deleting populated folder problem | Excel Programming | |||
| How to check if a folder/directory exist using VBA | Excel Programming | |||
Threaded Mode
