Thanks but I have many such files so how do I select them all into one excel sheet.
Please specify your requirement in detail, like
How many files do you have (in number),
Number of rows and columns in each file,
What you want to do with these files.
In how many files you want to convert these files.
Is the data of these files are of similar type (but of different dates only).
Which version you are using upto 2003 or 2007 and later.
If possible and if you wish, you may attach one file for reference and to understand what you want to do.
Perhaps myself or someone else may help you, after knowing your exact requirement.