Parts list to spreadsheet
Parts list to spreadsheet
(OP)
Is there an easy way to get a parts list output to the spreadsheet? Basically, all I would need would be part numbers and quantities. I have searched through help files and played around with the spreadsheet functions (what little I know about them) to no avail.





RE: Parts list to spreadsheet
"Wildfires are dangerous, hard to control, and economically catastrophic."
Ben Loosli
CAD/CAM System Analyst
Ingersoll-Rand
RE: Parts list to spreadsheet
RE: Parts list to spreadsheet
-export the partslist to a text file with a logic name
-copy one excel template file to the same folder (renamed)
-Open the excel file
Inside the excel file is some vba code that creates a link to the partslist textfile.
For the vba code we use Data..Get External Data..Import text file.
I hope this helps
RE: Parts list to spreadsheet
That looks like the route I'll have to pursue.