Hi,I am trying to write a VBA code to rename word document by referring the values in the column of an excel sheet For examble aaa, bbb, ccc, ddd in cell A1, cell A2, cell A3, cell A4 etc..... The files to be renamed and the excel file will be in the same folder The information in the excel sheet varies as there are instances where I will have more names in column A.How much ever names are there in column A they should be referred to rename the files in the folderI would really appreciate if some one would give me a better solution to my problem ASAP!!
