Has anyone found a way to link a cell to an external excel table cell value?
Here is what I am trying to accomplish:
Auto created BOM that looks like the attached image (generally). I would like to apply an excel "lookup" command to the description cell in order to pull from an external excel table. Essentially it will look up the part number in my master table and apply the related description. I know that I can have solidworks apply the sw property automatically but none of the part files have the properties filled out, and I really do not want to go back and edit them manually.
Is this something that can be done within the template or does it have to be done via some kind of macro?
Thanks in advance for any help!
Brandon
I don't see a way to do this without getting heavey into API and if you've got that kind of skill, it's a much simpler matter to use task scheduler to open each of your part files, query in the metadata from your excel item master and populate the properties of your files.
if you're not going to put the attribute data in your files, then I would query a bom in your excel item master, and then copy and paste the contents into a general table in the drawing. One note on pasting from excel into a general table: the table has to have the right number of rows and columns, otherwise, it will truncate.
Good luck.
JOhn