×
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

Help with 3D points macro, similar to faq559-1040

Help with 3D points macro, similar to faq559-1040

Help with 3D points macro, similar to faq559-1040

(OP)
I've been using solidworks for probably 3 years now, but I'm a total rookie with macros. I'm trying to create a table of 3D points for a piece of tubing that we want to get cnc-bent. I found the FAQ that exports it to excel, but it's not working for me. When i try to run it, I get the following message at the line "Dim exApp As Excel.Application":

Compile Error:
User defined type not defined.

Any ideas as to how I can cure this? Also, I would like to take it a step further and have the table inside my drawing instead of in a seperate file, so if anybody has ideas on how to do that I'd love to hear em. Thanks a lot

RE: Help with 3D points macro, similar to faq559-1040

You probably do not have a link to Excel in your macro VBA project.

Go to "Tools --> References" and look for something like "Microsoft Excel xx.xx Object Library".

RE: Help with 3D points macro, similar to faq559-1040

(OP)
Thanks, that was it

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