×
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

Custom Excel BOM

Custom Excel BOM

Custom Excel BOM

(OP)
I am trying to create a custom Excel BOM which consists of several lines of information before the actual columns from which SolidWorks will propagate its information.  When this BOM is inserted into a SolidWorks Drawing it shifts information, and duplicates information when CTL Q is selected.  Can anyone advise as to what I am doing wrong or perhaps if this is a known bug?  Any input is greatly appreciated.  Thanks

RE: Custom Excel BOM

That is because you removed the original columns. You Cannot remove these columns. You should hide the original columns keep the $END and insert Columns in front of (To the left of) the $END.

Regards,

Scott Baugh, CSWP
http://www.3dvisiontech.com
http://www.scottjbaugh.com

For all Newbie's - Welcome to the nerd herd!

FAQ731-376

RE: Custom Excel BOM

(OP)
Do the original columns have to be the 1st columns, or can information be inserted above them?

RE: Custom Excel BOM

I just simply hide them (Original Columns), then click the $END Column, then RMB and click Insert column.

Nothing can be entered above them as far as I know.

Regards,

Scott Baugh, CSWP
http://www.3dvisiontech.com
http://www.scottjbaugh.com

For all Newbie's - Welcome to the nerd herd!

FAQ731-376

RE: Custom Excel BOM

Quote (SWHelp):

The design table can include additional columns or rows for information only (notes, intermediate calculations, and so on). Use the keyword $USER_NOTES in the header of any column or row that you do not want evaluated. You may use as many of these rows or columns as you need. However, you may not include rows or columns with empty headers in the middle of the table.

The above quote is from SW Help file design tables, user notes index. Although it does not state that the first column should not be used, the example picture shows the $USER_NOTES being in the 2nd or "B" column.

from (the City of) Barrie, Ontario.

I tried sniffing Coke once, but the ice cubes got stuck in my nose

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