| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to test if a repertory is valid
Hello,
I want a function that test if any path is a valid path. This function makes an error when you are typing a path like the one writen below. Does anyone know how to stop this error? path = "VV:\temp\" If Len(Dir$(path, vbDirectory)) = 0 Then msgbox("the path is not valid") exit sub endif Thanks, -- Alex St-Pierre |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to do - B2 is only valid if B1 is zero | Excel Discussion (Misc queries) | |||
| Can you help test our Excel test? | Excel Discussion (Misc queries) | |||
| Calculate mean of test scores from rows of test answers | Excel Discussion (Misc queries) | |||
| test..where are my messages..test | New Users to Excel | |||
| Not A Valid Add-In | Excel Programming | |||
Threaded Mode
