The problem I want to solve is the following
As a company we have a selection of content center components on stock,
For new designs we want to limit the choices of content center components to those in stock.
I have an excel document with all the iso and DIN names of the parts in stock.
The VBA script I'm trying to write should loop over standard libraries and save the copy the parts which are in the excel file to a custom library
I’m still relative unexperienced in VBA,
But in pseudocode I think this needs to happen,
- Select ThisApplication.ContentCenter
- Dim oContentCenter As ContentCenter
- Set oContentCenter = ThisApplication.ContentCenter
- Use the LibarayManager to choose a standard Library
- Don’t know how to do this jet
- Select TreeViewTopNode
- Dim oTreeViewTopNode As TreeViewTopNode
- Set oTreeViewTopNode = oContentCenter.TreeViewTopNode
- Loop over the ChildNotes and check if the families are within the excel file.
- If true copy them to custom library. (Can not find a function for this yet)
I can enter different parts of my first library but I cant switch between different libraries and I’m not able to copy them to a custom library.
Could you tell me if this is possible,
And maybe help me how to proceed?
Kind regards,
Siard Kuipers
