Formula to test for existence of external file

[Guest]

Want to create a formula in Excel which tests for the existence of a second
Excel file. If the file does not exist (because it hasn't yet been created)
the formula should return a False value which can then be used to create a
blank cell rather than a cell containing an error status. Using Excel 2003.

 

[Franz Verga]

Want to create a formula in Excel which tests for the existence of a
second Excel file. If the file does not exist (because it hasn't yet
been created) the formula should return a False value which can then
be used to create a blank cell rather than a cell containing an error
status. Using Excel 2003.

Hi,

I think you could find something useful here:

http://www.erlandsendata.no/english/index.php?t=envbafolders

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[Franz Verga]

Hi,

I think you could find something useful here:

http://www.erlandsendata.no/english/index.php?t=envbafolders

Also here I think you can find something useful:

http://www.erlandsendata.no/english/index.php?t=envbawb

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy