I did this for a client a few days ago.
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


Send destination file and two sample source files.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KONGSIR" wrote in message
...
Dear Don ,Thank you very much!
let me clearfy it : some .xls files in a folder, with the same title line
and format. but the number of the .xls file is uncertain, maybe 3, maybe 4
or
maybe 36. and the name of the .xls files are not regular. the data in the
.xls files are not uncertain too, maybe 3 line, maybe 4 line, or even
more.
now i want to make all the data in one new file.
so what i want to do is " open each and copy the info from the source
file(s) to the
destination file."

Thanks again for help!

"Don Guillett" wrote:

You would want a looping macro to either make a formula in the
destination
file for each or open each and copy the info from the source file(s) to
the
destination file. More info needed.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KONGSIR" wrote in message
...
i sent worksheetbooks to my workmates, with title line like this:
"NO.,name, gender, project name, finish date, price" and so on, they
fill
the worksheet and then sent back to me. i kept all the files they sent
back
in a fold named "all data" i have to copy all the data to a new
workbook
and
save it as "original data".xls. the problem is i dont know how much
files
they would sent back, maybe some one won't sent back, and i dont have
regular
names of the files, and in each file, the data may be not just one row,
maybe
several rows. how could i do this job in VBA? because i have to do this
job
several times a month, it waste me a lot of time. thank you very much!

.