How to check if file a .pdf file exist in excel using formula only

[Cocojam]

Hello

Can anyone please help me to determine by using only formulas, whether a file exists (.pdf)?

The name of the file is in a Cell on a spreadsheet.

If the file does not exist then I would like to display a suitable message in another cell.

Thanks in advance.

Cocojam

 

[Dan_W]

When you say "formula only", does that mean no code at all? It's possible to create a custom function with VBA that you can call from the worksheet like a formula - would that work?

Function FileExists(FileName As String) As Boolean
     FileExists = Len(Dir(FileName)) > 0
End Function

 

[Cocojam]

Yes sir. Without using VBA. Only excel function formula.