Hi,

I currently have 300 files in a folder.

It includes, part, part drawing, assembly, assembly drawing.

I need to replace the existing numbers with a new number.

Existing number is in the first column of the excel and the new number is in the second column of the excel. (Like below)

Is there any macro available so that without losing assembly reference, i can rename all the files in the folder? (Regardless of the file extension)

I'm using Solidworks 2016.

Thank you in advance.

Regards,

Prasanna.A