| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't open existing files by double-clicking. | Excel Discussion (Misc queries) | |||
| It takes two full minutes to open existing files in Office 2003 | Excel Discussion (Misc queries) | |||
| cannot open an existing file in excel 2003 | Excel Discussion (Misc queries) | |||
| When I open a an existing excel worksheet, it duplicates itself a. | Excel Discussion (Misc queries) | |||
| Open existing Excel file | Excel Discussion (Misc queries) | |||
Linear Mode
