Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
SPALANIAPPANTN47S
354 Views, 2 Replies

How to change revision & state for a document & its models through vba?

I need to search drawing file & go to its folder , then need to change revision (1 to A) its state (Workin progress to Released) .

SPALANIAPPANTN47S_0-1612456220926.png

Please suggest vba code controlling from excel..

Thanks in advance

 

@CGBenner @JDMather  @Thomas_Savage 

@SPALANIAPPANTN47S 

 

For this you need to dig into Vault API, here are some resources for you,

 

https://justonesandzeros.typepad.com/blog/ (This is a really nice blog to start understanding Vault API)

 I also recommend you to install Vault SDK on your PC if not, it is the most extensive help, to get your hands on the Vault API,

 

Also, try searching for some content on AU classes, you may get some help. You may also get some readily available repositories on GitHub if you search for maybe in other programming languages (C# or Vb.Net) you might need to change them a bit as per your requirement, but please note that it is a bit specialized field, and difficult to understand if you are not so good with coding.

 

Hope this will be helpful.

 

If this answer has solved your problem please ACCEPT SOLUTION and hit like if you found it helpful..!


Regards,
Dutt Thakar
LinkedIn

@SPALANIAPPANTN47S 

FYI:  I don't know if this may be related since it doesn't involve Vault, but within the iProperties dialog, Status tab, all those properties shown (except for the ones inside the File Status area) are exposed and can be manipulated easily by code (iLogic or VBA) without Vault.  The property name for the 'Status:' field is "User Status".  The property name for the 'Design State:' field is "Design Status".  They are both in the "Design Tracking Properties" property set.  There is also an iProperty for the revision called "Revision Number" within the "Inventor Summary Information" property set, but it is a driven value, instead of the driving value, so it may not be useful for your purposes.

 

If this solved your problem, or answered your question, please click ACCEPT SOLUTION.
Or, if this helped you, please click (LIKE or KUDOS) :thumbs_up:.

Wesley Crihfield

EESignature

(Not an Autodesk Employee)