=@filepath()

[MetLife]

Hi.,

I have a workbook that use =@filepath() and several other similar commands. But these are returning "#NAME?" in the workbook.

=@bookname()
=@filepath()
=@lastsaved()
=@savedby()


Does anyone know how to get these functions working?

 

[Joe4]

I don't believe those are not native Excel functions. They would probably have to be some sort of custom functions, which would be:
- part of an external add-in
- a User Defined Function in VBA
- a Lambda function in the Name Manager (only available in Excel 365)

So where did these functions come from?

 

[MetLife]

I don't believe those are not native Excel functions. They would probably have to be some sort of custom functions, which would be:
- part of an external add-in
- a User Defined Function in VBA
- a Lambda function in the Name Manager (only available in Excel 365)

So where did these functions come from?

I'm not sure, it wasn't my workbook but I was asked to approve it as part of a template.

OK... I see there are functions in the module.

I wasn't aware that you could call a function with the @ symbol.
Function FILEPATH()
Application.Volatile
FILEPATH = ThisWorkbook.Path
End Function

 

[Joe4]

See here for an explanation on what the "@" means: Implicit intersection operator: @ - Microsoft Support.