User Define Functions not working from Personel.xls

Posted by nishith on April 01, 2000 6:48 AM

I have UDF which i have stored in Personel.xls and I tried to
call it from other active.workbook but got a #name error

Please tell me how should I call UDF from personel.xls.

I tried by making function as addins which worked fine,
but to load addins for few functions can eat up my memory
so I thought to store in personel.xls ,,,,

nishith desai

Posted by Ivan Moala on April 04, 2000 3:31 AM

Access your UDF via the format
='C:\Personal.xls'!Test(Function variables)

Where your input your File path between the '
and then your Function name and required variables.
OR
In the vba editor for the active workbook
reference it in via Tools/reference and select
Browse and select the file with the function.

Ivan