File|SaveAs
scroll down in the "Save As type" box to "Microsoft Excel Add-In (*.xla)"

Then change the folder back to where you want to save the file.

Remember to only keep personal.xls or personal.xla in your xlstart folder. (You
don't want both there.)

Vsn wrote:

Gordon,

Maybe very simple but could you tell me how I can save the 'Personnal.xla'
file as an Add-in?

Thx for your advice.

Ludovic
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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







--

Dave Peterson