I have this in the ALT-F11, module and I get a #NAME? in the resulting cell.

Public Function Filethere(strFullPath As String) As Boolean
If Not Dir(strFullPath, vbDirectory) = vbNullString Then Filethere = True
End Function

The data looks like this.

A B
c:\text.txt =Filethere(A1)

The result is #NAME?

Basically none of my UDF's are working - any suggestions?

a UDF MUST be in a REGULAR module. It may not reside in a sheet module or
ThisWorkbook module.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rookie_User" wrote in message
...
I have this in the ALT-F11, module and I get a #NAME? in the resulting
cell.

Public Function Filethere(strFullPath As String) As Boolean
If Not Dir(strFullPath, vbDirectory) = vbNullString Then Filethere = True
End Function

The data looks like this.

A B
c:\text.txt =Filethere(A1)

The result is #NAME?

Basically none of my UDF's are working - any suggestions?

Hi,

If none of your UDf's are working then maybe you have macros disabled. If
you have, this UDF even though it works correctly will give a name error.

Close and reopen ensuring macros are enabled.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Rookie_User" wrote:

I have this in the ALT-F11, module and I get a #NAME? in the resulting cell.

Public Function Filethere(strFullPath As String) As Boolean
If Not Dir(strFullPath, vbDirectory) = vbNullString Then Filethere = True
End Function

The data looks like this.

A B
c:\text.txt =Filethere(A1)

The result is #NAME?

Basically none of my UDF's are working - any suggestions?

Hello,

...
If none of your UDf's are working then maybe you have macros disabled. If
you have, this UDF even though it works correctly will give a name error.
...

Or you have all single UDFs in modules with exactly the same name as
the functions :-)

Regards,
Bernd