Thread: Functions
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Vsn[_3_] Vsn[_3_] is offline
external usenet poster
 
Posts: 1
Default Functions

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