(VBA) How do I create a custom BOM quantity and coordinate system property automatically on SOLIDWORKS?

3D Design
1

Hi all

 

I'm looking for a solution to automatically create a property in each part of an assembly so that I can create drawing sheets for each of these parts and thus annotate their quantity. 

I saw this excerpt from an online training course: Introduction to APIs and Programming in SolidWorks | A-S3D - YouTube. The trainer at 2" in the video shows us an example and that's exactly what I would need. I did manage to create a custom property automatically via a macro, but I don't know how to indicate that this is the quantity I want for each of the parts in my assembly.

I also have this problem for the coordinate systems of the parts of the BOM. I would like to achieve the same thing but I have no idea if it is possible.

 

Thank you in advance.

2

I see that you have access to Visiativ's MyCadTools tools for free as a Mycad subscriber.

These tools can allow you to do what you want without any vba or programming knowledge (so much simpler)

One of the uses of these tools for us is to export an excel bill of materials with quantities for each part and assembly via the Smartbom utility.

This quantity can then be retrieved with Integration in order to export a plan of each room and fill in the quantity previously retrieved on the fly. (batch property modification by retrieving a value from the Excel table)

For the link:

https://www.visiativ-solutions.fr/video-testez-gratuitement-mycadtools/

 

If necessary I can guide you on how to do it.

1 Like
3

Thank you for your answer,

Indeed, I had looked at the Smartbom tool. The method you propose does not really meet my expectations in the sense that, from what I understand, each room will have a plan and therefore a file and not just a file with the overall plan as well as all the other parts on different sheets for example. 

Maybe I'm wrong and it's possible to have only one file?

4

This method must be more complicated to set up in this case indeed.

For our part, we don't like the fact of making a drawing with lots of paper, it quickly becomes heavy and unmanageable.

That's why we made our solution one piece = a plane of necessity. (In addition, a part can be reused endlessly for other purposes)

Then, with pdfs, nothing prevents you from merging everything into a single pdf file. (with pdfSam for example)

So for you this may be achievable but it is certainly more complicated unless you change the method for making MEPs.

Otherwise there will be the macro method, but it will be a bit cotton and I hope you have a good foundation in programming. I do it from time to time but your subject will not be easy.