[SOLVED] How do I test for an external file?

[CarlB]

I would like to test for the existing of an external file from within a cell formulae e.g.

if c:\users\carl\tst.txt exists then output "Yes" otherwise output ""

Is this possible in OO Calc?

Any help much appreciated

[RusselB]

Welcome to the Forums.
Based on the wording of your request, while Calc might be able to do this, I believe it would require a macro.
I'm not familiar with macros, but a quick Google search brought up https://stackabuse.com/python-check-if- ... ry-exists/
As this is a Python code, it (to my knowledge) is compatible with Calc, and thus may be what you are wanting.

[Zizi64]

You can test it with a macro written in the Basic. The Basic has IDE in the AOO/LO. The usage of the Basic maybe easier than the Python for a beginner.

Code: Select all

REM  *****  BASIC  *****
Option explicit

Function MyFileExists(sFullPath as string) as boolean

 dim sFileUrl as string
 
	sFileURL = ConvertToUrl(sFullPath)	
	
	If FileExists(sFileUrl) then 
		MyFileExists = True
	else 
		MyFileExists = False
	end if
End function

Copy the code into a Module of the MyMacros, and then you will able to call the function from a cell of any spreadsheet document.

[CarlB]

That's great thanks