Hello all,

Can some one tell me what I do wrong, I am new in automating Excel.

I made a VB(A) function which should return the name of the day given by a
date.

Function fDayName(dteDate as Variant)
'Code
End Function

I did save it in the template 'Personal.xls '

I thought I could use it now in any cell on the spreadsheet like
=fDayName(A1), as you use the normal build in functions of Excel.
Unfortunately it returns with an error #NAME? If I open Excel and go into
the VB editor I can see the file "Personal.xls' loaded as well I can call
the function from the immediate window.

What am I doing wrong here?

Thx for your help.

Ludovic