Thread: missing file
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jnewl jnewl is offline
external usenet poster
 
Posts: 28
Default missing file

i have a macro that retrieves csv files, creates pivot tables and builds
excel workbooks. these csv files are from different programs, so my macro
executes a series of macros to get the excel books.
this job is run monthly and some of these files are not available because of
a lack of data. what statement can i use to check for missing file and bypass
the macro so that my master macro does not abend?

thanks