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

Open only existing Excel Files in a given Range
 

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