Dear all, I am new to VBA, I would like to see if I can get the file names of some text files with extension .asc and .asa and also count the number of rows in each file and append it to an excel worksheet? Many thanks for your help!