61 Replies Latest reply on Feb 21, 2019 1:36 PM by Deepak Gupta

    Macro: Batch Reload-Replace Drawing Sheet Format (sub folders as well)

    Deepak Gupta

      Sharing a macro for batch reloading of drawing sheet format. Here are some main points of the macro:

       

      1. It works for all drawing files in the selected folder.
      2. It works on all sheet and not just active or single sheet.
      3. It works with mixed sheet format sizes. You can add/edit sheet formats as needed.
      4. It detects the width of the current size and pick the required sheet format based on that.

       

      Feel free to edit as needed. Suggestion/enhancements are welcome

       

      Please backup your data before use.

       

      Message was edited by: Deepak Gupta Added another version of the macro with new codes to simply reload the sheet format when name is same.

       

      Message was edited by: Deepak Gupta on 01/30/19 Added updated macros for processing files in the sub folders as well. Macro V3A reloads the same sheet format and macro V3B reloads the specified sheet format based on paper/sheet size.

       

      Message was edited by: Deepak Gupta on 01/30/19 There was a small typo in the sub folder processing codes. revised macros have been uploaded.