22 Replies Latest reply on May 8, 2013 10:04 AM by Tim Webb

    Automatically check Document Status/State in EPDM

    Steven Tan

      Hi,

       

      I'm new to Solidworks and Enterprise PDM.

      I'm needed to constantly monitor the status/state of documents stored in EPDM.

      My problem is the document names are listed in Excel or Access, and all the document/drawings are not from the same Assembly.

       

      Therefore, I would like to check with the experts here, if there is a VBA code that will do the following.

      Maybe with a click of a button.

      1) Read the Document Name from a column "Document Name" in excel.

      2) Search the document name in EPDM.

      3) Get the Latest Revision.

      4) Extract the "State", "Revision", "Modified", etc, information from EPDM.

      5) Populate the latest information into the column "State", "Revision", "Modified", etc in Excel/Access.

       

      Currently, I had to do this manually, and it's taking alot of my time.

      Any help in this will be good.

       

      Thanks in advance.