Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations JAE on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Linking attributes to .xls?
- Thread starter moon161
- Start date
- Thread starter
- #2
btrueblood
Mechanical
It can be done.
Things to think about:
- what happens when MS releases a new version of Excel, and the old link stops working, ditto for new releases of Acad.
- what happens if somebody on another PC in your company tries to edit your drawing, do they need access to the .xls file, and can you guarantee that the file won't get lost?
- same as above, but the user blows away your .xls import and overwrites the info with a text box...
Things to think about:
- what happens when MS releases a new version of Excel, and the old link stops working, ditto for new releases of Acad.
- what happens if somebody on another PC in your company tries to edit your drawing, do they need access to the .xls file, and can you guarantee that the file won't get lost?
- same as above, but the user blows away your .xls import and overwrites the info with a text box...
- Thread starter
- #4
Good points. I revise drawings, and the BOM usually predates or does not match the MRP system. Presently I can copy the part number from the BOM into ERP, open the doc and copy revised descroptions into the BOM item at about 1 minute per item, before I used that important neuron, I transcribed and got typos redlined ;(.
A one time import of .xls into a stack of attribute blocks would be a mild sort of revolution.
A one time import of .xls into a stack of attribute blocks would be a mild sort of revolution.
- Status
Similar threads
- Locked
- Question
