I currently have a macro to extract information from a part into an Excel file, such as its description and weight. I'm using the following:
ModelDoc.CustomInfo2(Configuration.Name, "Description")
ModelDoc.CustomInfo2(Configuration.Name, "Weight")
However, I'm having a problem with the weight...
Okay, I guess this is what I have in mind:
Assuming I have a list of Path + File names of assembly drawings in Column A in an Excel file:
Set swApp = CreateObject("SldWorks.Application")
For i = 1 to Range("A65536").End(xlUp).Row
PathName = Cells(i, 1).Value
Set swPart =...
Wow thanks, this definitely looks very useful.
Unfortunately I guess my VBA knowledge really isn't that great... This macro requires that I run it from SolidWorks. Anyone by any chance know how to get started from Excel?
Summary: I wish to automatically obtain the Bill of Materials (BOM) from a SolidWorks assembly file (.SLDASM) and import it into Excel.
I'm somewhat familiar with VBA. I have an Excel file with a list of file location and file names. From here I want to create a connection to SolidWorks (via...
