7 Replies Latest reply on Aug 23, 2017 3:52 PM by Jonathan Jonathan

    Bulk Renaming of files (Part, Assembly, Drawing) through excel

    Prasanna Ashok

      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)

       

       

      6030.41.00.005738852t
      6030.41.00.005838852j
      6030.41.00.006238852r
      6030.41.00.006338852k

       

      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