Yeah, not bad - nishantp's is the best attempt so far, this is the fastest way (as was proved by some gurus on this site ages ago with nothing better to do than test this ) ...
Code:
If (Len$(Dir("C:\YourPathHere\")) <> 0) Then
    Msgbox "Yep, it's here alright !"
End If
So there ! pphhhtttt