Ludovic

If you save your Personal.xls as an Add-in and reference the UDF from there,
you do not have to preface with the filename.

Gord Dibben Excel MVP

On Sun, 25 Apr 2004 00:15:15 +0800, "Vsn" wrote:

That is not a very nead methode, I will probably have to speak with Bill
about this.

But I works, thanks for you help.

Ludovic

"Don Guillett" wrote in message
...
To use a UDF from any other workbook including personal.xls use
personal.xls!Function fDayName(dteDate as Variant)


--
Don Guillett
SalesAid Software

"Vsn" wrote in message
...
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