View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dan Thompson Dan Thompson is offline
external usenet poster
 
Posts: 125
Default How do you ignor File Not Found Dialog Popup ?

Workbooks("Master.xls").Worksheets("UpdatedList"). Cells(rw, 2).FormulaR1C1 =
"='[" & FileName & "]PointCount'!R2C5"

The above is my line of code that inserts a formula into a cell in my
Master.xls workbook the formula links to a value in the worksheet called
PointCount from multiple different workbooks. the problem is that if the
program encounters a workbook that does not have a worksheet named
"PointCount" I get a pop up FileNotFound window asking me to browse to the
file that has the worksheet "PointCount" I do not want it to do this. Is
there a way to have my macro skip over these files or suppres the "File Not
Found" Pop up from poping up ?