How can I determine that a directory exists, it is
valid.

For example: Is "C:\imports\" a valid directory?

Thanks

Ross,

Here is one way to do it:

If Len(Trim(Dir("c:\imports", vbDirectory))) > 0 Then
MsgBox "folder exists"
End If


hth,
--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


"Ross" <(E-Mail Removed)> wrote in message
news:8cb601c3e9b0$eadb1c90$(E-Mail Removed)...
> How can I determine that a directory exists, it is
> valid.
>
> For example: Is "C:\imports\" a valid directory?
>
> Thanks
>
>

But whack an On Error around it, just in case the path contains an invalid
drive letter (for example).

TC


"Cheryl Fischer" <(E-Mail Removed)> wrote in message
news:unQ$(E-Mail Removed)...
> Ross,
>
> Here is one way to do it:
>
> If Len(Trim(Dir("c:\imports", vbDirectory))) > 0 Then
> MsgBox "folder exists"
> End If
>
>
> hth,
> --
>
> Cheryl Fischer, MVP Microsoft Access
> Law/Sys Associates, Houston, TX
>
>
> "Ross" <(E-Mail Removed)> wrote in message
> news:8cb601c3e9b0$eadb1c90$(E-Mail Removed)...
> > How can I determine that a directory exists, it is
> > valid.
> >
> > For example: Is "C:\imports\" a valid directory?
> >
> > Thanks
> >
> >
>
>