Hi,, i am looping all the files present in a folder and searching for the given cell value "Order Date". If this cell value matches in cell range C2, then rename the excel file name as "Praveen.xls".
My code is below and after this line (If ActiveSheet.Range("C2").Value = "Order Date" Then) it...