View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Al at Novelis Al at Novelis is offline
external usenet poster
 
Posts: 1
Default Formula to test for existence of external file

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.