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