View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] aidan.heritage@virgin.net is offline
external usenet poster
 
Posts: 244
Default Run macro <iif</i 001.xls exists

Are all the files in the same directory? If so, why not simply use the
FindFile method to get ALL the existing files and manipulate them as
necessary. Failing that, an ON ERROR GOTO statement would probably
resolve it.