Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In cell B4 I have (as text):
C:\Documents and Settings\XlsFileSavedAsText.txt In Cell C2 I have: =PathExists(B4) In my Module1 I have: Private Function PathExists(PathName As String) As Boolean ' Returns True If PathExists On Error GoTo NoPath x = Dir(PathName & "\*.*") If x = "" Then GoTo NoPath PathExists = True Exit Function NoPath: PathExists = False End Function Why is my Cell C2 showing False when I definitely C:\Documents and Settings\XlsFileSavedAsText.txt Exists? TIA, Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Gap or something I cannot understand | Excel Discussion (Misc queries) | |||
not understand | New Users to Excel | |||
I don't Understand | Excel Worksheet Functions | |||
Help me understand this code | Excel Discussion (Misc queries) | |||
< |
Excel Worksheet Functions |