UDF Not recognized
 

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?

UDF Not recognized
 

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?

UDF Not recognized
 

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?

UDF Not recognized
 

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