×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Lenny's AssemblyBOM macro

Lenny's AssemblyBOM macro

Lenny's AssemblyBOM macro

(OP)
I am using Lenny's AssemblyBOM macro (http://webpages.charter.net/mkikstra/SWXMacros/AssemblyBOM.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.

RE: Lenny's AssemblyBOM macro

ModelDoc2::GetCustomInfoValue

RE: Lenny's AssemblyBOM macro

(OP)
Thanks for the info, but I'm going to need a little more help than just that. I'm not too VB literate, and after reading through the code, I can't find what it is that I have to change.

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

Look for lines of code that have CustomInfo2 in them.  The API call looks like this in API help.

CODE

value = ModelDoc2.CustomInfo2 (configuration, fieldName)

SA

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources