View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matty C Matty C is offline
external usenet poster
 
Posts: 1
Default Open only existing Excel Files in a given Range


Hi All,

I need to compile data from multiple Excel files into one. The file
are named "string" + # + "string" and the #'s are within the range o
274 to 307 but there are some numbers missing. Is there any way t
tell my macro to only open existing files within my range?

Thank

--
Matty
-----------------------------------------------------------------------
Matty C's Profile: http://www.excelforum.com/member.php...fo&userid=1436
View this thread: http://www.excelforum.com/showthread.php?threadid=26617