0 Replies Latest reply on Apr 8, 2015 8:22 AM by Raphael Schubert

    VBA Function to find what revision is one file inside PDM

    Raphael Schubert

      Hello guys, i'm drafter and know a little bit about VBA.

      I have an Excel Workbook where i created a function to search all files inside an location of my network.

      I want to know a way to use VBA inside excel to retrieve an especific file revision.

       

      Sample.

      My sheet:

      Draw Number ( is same as file name ) - ARX000-000-001

      Column B - Revision 012

       

      When i call the Macro, it will run inside Solidworks PDM and find this file and compare if revision in PDM was same in excel file.

       

      Why i need? I have some DWG files i use in Laser Cut Machinary. I need know if other Drafters was changing those files when have a new revision.

      How i will do it?

       

      Simple.

       

      I will run for first time macro inside my local folder with DWG's and assume all was in correct revision and save Data/Hour i checked.

      When i run the macro again i'll compare all versions and if any was wrong it will show me an message to open file and export again the DWG.

      Maybe i can alter the script to delete the old DWG. I'm thinking what will be bether here.

       

      I know do almost all.

      But i dont know what function i will use to locate the file revision inside PDM.

       

      Can someone help me with it?

      If i got some help here i can give the Excel File when done with script.

       

      Att, Raphael Schubert