Hi all,
I want to create a macros to load multiple text files from a directory say c:\test ,ther text files are of the form a1,a2,a3.....a100 , i have to load it in excel and delete the first row and then save it again in the same directory as excel files like a1.xls,a2.xls,a3.xls..

can anyone help me with this.

thanks,
sanka