Hi All,

I was wondering what code i would need to obtain all the file names in a given folder, for arguments sake lets just say it's "C\Test".

I also need the code to trim the fle name down so that the ".xls" is missing, that was i will have each name.

hope thats clear

Thank you for reading this tread and for any help give