Parts list to spreadsheet

[cowski]

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.

 

[looslib]

The BOM is an embedded function until you get NX2. The only thing you can do is export it as a text file.


"Wildfires are dangerous, hard to control, and economically catastrophic."

Ben Loosli
CAD/CAM System Analyst
Ingersoll-Rand

 

[cowski]

Thanks for the reply, Ben. So, this would be possible in NX2?

 

[GunnarS]

With one Grip program we do:
-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

 

[cowski]

Thanks, GunnarS.
That looks like the route I'll have to pursue.