UDF "FileName" and Cell("filename")

[BuddieB]

I created a UDF that returns the filename of the active file:

however, when I named the file I forgot that the CELL function has an option for "filename". Is there a way to remove an older UDF such that my CELL function will work. I have already tried renaming the UDF to FName, but now XL doesn't recognize FName as a function, and it still recognizes FileName as a function.

I have these UDF's stored in my personal.xls file if that matters and I am running XL2000 on Win2000

I can't seem to figure out why it wont reconize the new UDF name?

EDIT: Here is my new function code if that matters:

Public Function FName() As String
    'i.e. [file.xls]
    Application.Volatile
    FName = ActiveWorkbook.Name
End Function

 

[Joe4]

If you don't need the UDF anymore, why not just remove it from your personal.xls file altogether?

 

[BuddieB]

I just realized where it came from...

I loaded the MOREFUNC.XLA recently and it has a UDF in it with the name FILENAME, which precludes the use of the CELL("Filename") embeded worksheet function.

When I unloaded the Add-in, it took care of my problem.

Just a thought, but whomever wrote the MOREFUNC, might want to think of renaming that UDF, to prevent this conflict. Just a thought.

 

[GregMcC]

You are missing the point - this UDF was written as a workaround the volatility of the standard CELL("filename") function. See MSDN website Q211370


http://support.microsoft.com/default.aspx?scid=kb;en-us;211370