View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
swar phil swar phil is offline
external usenet poster
 
Posts: 1
Default stop error message when opening a non existant file in a macro

In a macro jn Excel 2007, I am opening files from a list, when the file
doesn't exist I get an error message. How can I stop this and go on to the
next one? I can stop the first with an onerror statement but if it finds a
second non-existant file it ignores this and gives an error message.