View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Multiple files question

Hi Alex

Look here for examples
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"alexm999" wrote in message
...

i have several files with many rows of data. Each file is in the
format:
filename-1.xls
filename-2.xls
filename-3.xls

and so on... Is there an easy way to combine these files into 1 large
file named: filename-total.xls ?

I get about 3 to 12 of these files a day and i'm sick and tired of
combining them manually! Please help...


--
alexm999
------------------------------------------------------------------------
alexm999's Profile: http://www.excelforum.com/member.php...fo&userid=4918
View this thread: http://www.excelforum.com/showthread...hreadid=519543