Thread: Formula to test for existence of external file
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Franz Verga Franz Verga is offline
external usenet poster
  
Posts: 459
Default Formula to test for existence of external file
Al at Novelis wrote:
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 he

http://www.erlandsendata.no/english/...t=envbafolders

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy


Reply With QuoteReply With Quote