Solidwork BOM Excel Macro
Solidwork BOM Excel Macro
(OP)
Although it is easy to export the BOM of a drawing to excel - is there a way where I can upload that data back into Solidworks?
Say you have a BOM where only the 'item', 'qty' and 'part number' have data. The other columns such as 'description', 'material', 'hardness' are empty.
I would like to export that BOM to excel (easy) where I can add the rest of the data (easy + fast). Now comes the hard part...is there a way were I can read the data from the modified excel BOM and write it back into the appropriate Solidworks part?
Thanx,
Tim
Say you have a BOM where only the 'item', 'qty' and 'part number' have data. The other columns such as 'description', 'material', 'hardness' are empty.
I would like to export that BOM to excel (easy) where I can add the rest of the data (easy + fast). Now comes the hard part...is there a way were I can read the data from the modified excel BOM and write it back into the appropriate Solidworks part?
Thanx,
Tim






RE: Solidwork BOM Excel Macro
The SW08 BOM is bi-directional and is almost as quick and easy to add data as Excel.
RE: Solidwork BOM Excel Macro
RE: Solidwork BOM Excel Macro
]i]"This is a test to see how much text can be placed
into a BOM cell; specifically the Description
column. So far it looks like I'm up to four lines of
approximately 8 or 9 words per line."[/i]
I'm experiencing no noticeable lag in switching from cell to cell.
RE: Solidwork BOM Excel Macro
RE: Solidwork BOM Excel Macro
I cannot copy text into multiple cells. It has to be copied one cell at a time.
The amount of text in the Summary information is limited to one line apparently. The standard SW BOM I used placed the Description in the Configuration Specific section of the properties.
RE: Solidwork BOM Excel Macro
RE: Solidwork BOM Excel Macro
RE: Solidwork BOM Excel Macro
Select cells to be edited > RMB > Edit multiple property values
Very good, I hadn't noticed that option.