adding 1000 excel files

Giganews Newsgroups
Subject: adding 1000 excel files
Posted by:  A.A.A (ayafe…@yahoo.com)
Date: Fri, 11 Jul 2008

Hi all,

Is there an excel macro thta can merge 1000 excel files? I have 1000
excel files named measure1,measure2,.....,measure1000. Each file
contains one number in the cell "A2". I want to merge these files in
one excel file so that this excel file has just one column and 1000
rows displaying the 1000 numbers. Is this possible with
excel??????????????????/

Aya

Replies