• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

File rename from a folder and update the status in a column


New Member

I need a vba code to change the lists of file names in a folder and update the status as complete as an when the file is renamed.

Marc L

Excel Ninja
Hi !​
To be honest, I haven't a clue what you want to do.​
My crystal ball is in the shop for an upgrade, so I am completely lost.​
Please explain at least exactly what you wish to accomplish …​


New Member
sorry for not being descriptive.
In column A i have the old file names which are placed in a folder
In column B i have the new file names for which the files are to be renamed
In column C i would need a status column mark as completed as and when the file names are renamed

Need the status to be updated against each of the file line items. Hope this would suffice for your understanding