Full Path (folder/name.extension) in Excel BOM

Out of category
1

Hello

I have a macro that generates an excel nomenclature.

This macro uses a BOM template for drawing of type: .sldbomtbt

On the other hand, I can't display the "Full Path" in this BOM. The original SW properties only allow you to display the folder, and the file name without an extension... Impossible to know if we are on an SLDPRT or an SLDASM otherwise I could have always concatenated the 3 columns???

I would also like to have an indented BOM type 1.2.3.4 but without the details of the welded parts.

 

SMART-BOM does this very well, so I'd actually like to do exactly the same thing that Smart-BOM does but within my own marco, an idea ???

2

Hello

If you have EPDM, via the BOM module  , it is possible to output an excel file with the file name with extension  and found in.

From solidworks, I don't know if it's possible. Maybe via explore sw!

CDLT

3

A similar question has already been asked, but it remains to be found.

In the end, it wasn't that far away: https://www.lynkoa.com/forum/solidworks/r%C3%A9cup%C3%A9rer-la-valeur-extension-de-fichier

1 Like
4

Hello

 

stefbeno: Thank you very much, I actually got some of this code to add the full path in a collone.

It works but I think it may not be optimized...

The method has the advantage of allowing you to add other properties that you can't normally put in the BOM template for drawing.

So that's very helpful.

 

On the other hand, the only way for me to get a BOM without the soldered parts list is to delete the lines with an empty "SW-filename", which again is not optimized, it's a shame to generate all these lines to remove them later....