Lenny's AssemblyBOM macro
Lenny's AssemblyBOM macro
(OP)
I am using Lenny's AssemblyBOM macro (ht tp://webpa ges.charte r.net/mkik stra/SWXMa cros/Assem blyBOM.zip) with SolidWorks 2006. After entering properties for each of the parts in my assembly (via File -> Properties -> Custom tab), I use the macro to extract that information, and then export it to an Excel file. When entering such properties as Mass and Density, I use the SolidWorks formulas (e.g. "SW-Mass@LED.SLDPRT") in the "Value / Text Expression" field and obtain their values in the "Evaluated Value" field. My problem is that the macro extracts information from the "Value / Text Expression" field and outputs the FORMULAS into the BOM instead of the evaluated values. What should I modify in the code to get the macro to output the evaluated values into the BOM?
Any help will be greatly appreciated.
Any help will be greatly appreciated.






RE: Lenny's AssemblyBOM macro
RE: Lenny's AssemblyBOM macro
Does anyone know of any other macros that perform the functions that I require. That will save me the trouble of trying to modify Lenny's macro.
RE: Lenny's AssemblyBOM macro
CODE
SA