Reading Vault files properties inside Excel VBA

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Good afternoon!
I hope my IT skill is not too low to ask something here... 😉
Here is my problem: I want to verify (each day) if there is nothing wrong in my Vault files (we use Vault Professional 2018).
For example, I would like to verify that there aren't 2 files with the same part number, that a 3D-model and its drawing are in the same folder, that no files are in a certain folder, count how many files there is in a certain category, make a list of the files used inside an assembly, count the number of files modified by a certain user account, ...
As a summary, I want to read a lot of information that are inside Vault, and I want to use them inside Excel thanks to Visual Basic VBA. I don't need any forms, I want something very easy and I will simply use Excel sheets and cells to write the answers.
When I was young I made some small softwares in Visual Basic 6, I also know how to make small operations, comparisons, and work with cells inside Excel VBA.
I already installed the Vault SDK.
I also installed Visual Studio Express and tested the examples that are inside the SDK folder, VaultList and VaultBrowserSample works! So my computer is well configured.
But for the moment I don't know and I request your help for:
- loading the right Autodesk DLLs inside VBA (I absolutely don't know how to do it)
- login into Vault through Excel VBA (I want to use the standard Vault window available through the API)
- read a property from a file
- make searches and get a list of the files whose title looks like "motor***15.ipt" for example
- list the files that are inside an assembly
- list the "used in" cases of a file
- ...
I am a newbie.... 🙂 Can someone help me, or give me a website link where I can find the answer?
Thank you all 🙂