1 Reply Latest reply on Jan 19, 2018 8:31 AM by Ulf Stockburger

    VBA to access BOM in PDM?

    Casey Bennett

      All - I apologize if this is already out there, but I am very new at this.  I have searched and found quite a few discussions, but they seem to be a bit over my head. 


      I am decent at writing code in VBA and was hoping that it would be relatively easy to do the following: Prompt a user with a dialogue box to select a file from the vault and then the code should return the BOM contents.  In particular, I'd like to know how to return the "Top Level" and the "Indented" BOMS.


      I am not picky about how it is returned.  I can be a data structure within VBA or simply saved as a .CSV file or the like.


      I see quite a bit of information out there on doing things in C# or even VB.NET, but both are a little out of reach for me right now.  Is this possible in VBA?


      Thanks so much for reading.