×
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

Can a excel macro automate a report of a solid edge assembly file

Can a excel macro automate a report of a solid edge assembly file

Can a excel macro automate a report of a solid edge assembly file

(OP)
I would greatly appreciate to be advised of the code required, that is if it can be done. The purpose of this is for BOM generation.
Manual procedure for this is right click on the assembly file (.asm ) and then select the command report.

Thanks in anticipation
Nodski

RE: Can a excel macro automate a report of a solid edge assembly file

You can use a VB macro to write data to an excel file, so you should be able to use the vb built in to excel to extract the BOM data from the assembly and import it.
If  was doing it I would opt for the first option - do the macro in VB and use it to write into an excel file.

bc.
2.4GHz Core2 Quad, 4GB RAM,
Quadro FX4600.

Where would we be without sat-nav?

RE: Can a excel macro automate a report of a solid edge assembly file

(OP)
Hi Beachcomber,
Thanks for your response...
Excel does not record outside of office or i am missing something ?
 

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