×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Parts list to spreadsheet

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

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

RE: Parts list to spreadsheet

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

RE: Parts list to spreadsheet

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

RE: Parts list to spreadsheet

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources