×
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

edit excel based bom template

edit excel based bom template

edit excel based bom template

(OP)
Trying to find out how to edit the excel bom template to include a column for Solidworks folder name so that I can keep track of the locations of all parts in an assembly (w/out opening SW). What needs to be typed in the Name Box in Excel to get this to work? For example, for part numbers you have to have partno in Name Box, however I'm not sure where this is pulled from in solidworks - my part number in properties is PartNumber

RE: edit excel based bom template

Could you just add a column with a hyperlink before the End column. You'd be able to see them in Windows Explorer without launching SW. It wouldn't be automatic though unless you could write an equation for it. Sylvia

RE: edit excel based bom template

(OP)


The first shows the typical SW table with a column for folder name added and the locations are generated. For an Excel based BOM you start one from a template. However, the supplied templates aren't very tailored (no folder name). I want one similar to the SW BOM but with the advantage of it being external. Need the proper syntax for writing in Excel so that the folder locations will populate automatically.

RE: edit excel based bom template

Here's a solution using Custom Properties.
Edit List on Property tab.
Add SWFolderName.
In Value/Text Expression add - $PRP:"SW-Folder Name" . (if you can find a way to add this to the list it would be a big help)
The Evaluated Value should show your file path.
Make a copy of the BOM that you want to change in Excel and rename.
Add a column in the appropriate place to the left of $$END.
At the top of the column type in your header.
Click on this cell, go to the Formulas ribbon, click on Define Name.
Type SWFolderName (no spaces or hyphens)

RE: edit excel based bom template

(OP)
felix7502, this may work, it would still require me going through all my parts/assemblies and updating the custom properties to show the folder path. The native SW BOM uses windows folder locations of the part to populate the BOM. That is what I was hoping to include in my Excel version.
Thanks!

RE: edit excel based bom template

I think you could write a macro to update Properties. Good luck with your quest.

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