Hi,I have a requirement that i am trying to code,i have 2 environments beta and prod that has reports (30+).these reports are in .xls format.Eg:Beta report:AUD210ba_-_Research_Ratings_Audit.xls
and prod report is AUD210ba_-_Research_Ratings_Audit_Prod.xls.similarly with all the reports.the requirement is i have to browse thru the directory of the given path and get the first report and browse thru the same directory and match this name with "_Prod" extension file and then compare 2 files sheet by sheet and create a report.I have the compare subroutine and the report creation.but the challenge is i am unable to loop thru the files and get the files with simliar names.Need advice.