2 Replies Latest reply on Nov 19, 2015 12:36 PM by Oskars Milbergs

    Drawing sheet sizes to excel

    Oskars Milbergs

      Hi! I have a problem finding macro which could export drawing sheet sizes of all my drawings to excel. I have hundreds of drawings with diferent sheet sizes but I can't tell what kind a sheet size is in each drawing without opening them. Could anyone help me?

        • Re: Drawing sheet sizes to excel
          Amen Allah Jlili

          Do your drawing files have more than one sheet? Things will get a little tricky if so.


          The optimal way is to program a standalone application that utilizes a backgroundworker class  to allow you to multi-task (run other processes simultaneously). The reason behind this is because as far as I know the only way to get the property of sheet formats is by opening 100s of files one at a time.  That would be time-consuming and would block the solidWorks entirely. That is still achievable via VBA but it will freeze the solidworks application.