try opening each f using an onerror statement to bypass those that don't
exist.


--
Don Guillett
SalesAid Software

"Matty C" wrote in message
...

Hi All,

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

Thanks


--
Matty C
------------------------------------------------------------------------
Matty C's Profile:
http://www.excelforum.com/member.php...o&userid=14366
View this thread: http://www.excelforum.com/showthread...hreadid=266174