×
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

Is it possible to import sketch points from external data source (xls)
2

Is it possible to import sketch points from external data source (xls)

Is it possible to import sketch points from external data source (xls)

(OP)
I'm looking for a way to import sketch points into a sketch.  The sketch is used as a sketch driven pattern for other features.  The sketch (pattern) contains hundreds of points that are currently in an excel spreadsheet.  It seems silly to one by one select a point then enter the xy coords then "fix" it in place.  Is there an easier (less manual) way of doing this?

tia

John

RE: Is it possible to import sketch points from external data source (xls)

(OP)
Tick - I downloaded the macro... created a new part (for testing the macro), then ran the macro.  It generates an error..

Run-time error '71':
Disk not ready

Q:  Is the txt file with the macro file the xy data source?  Or am I doing soemthing wrong?

John

RE: Is it possible to import sketch points from external data source (xls)

(OP)
Tick - Nevermind, figured out the problem.  THe macro was pointing to a temp dir on D:\ (which is my CDROM).  Changed the drive letter to C:\ and it works great!

Thanks!

RE: Is it possible to import sketch points from external data source (xls)

I might have a slightly improved version of that macro in my file pile.  I'll check this evening.

RE: Is it possible to import sketch points from external data source (xls)

Hey JWAGSTAFF...
Are you - by chance - making airfoil templates?

I'm gonna check this thread for replies - I wanna do that too!

tatej usfilter.com

RE: Is it possible to import sketch points from external data source (xls)

TheTicK,

I would be interested in your improved version of that macro.  I'm doing some gerotor profiles and have coordinate data to read in.  I would appreciate notification.  Thanks

Vince

RE: Is it possible to import sketch points from external data source (xls)

Hey all,

Anybody have an updated link for that macro? Doesn't seem to be working for me.

Thanks

Dave

60% of the time, it works every time.

RE: Is it possible to import sketch points from external data source (xls)

Cheers smcadman

Happy thanksgiving Canucks

60% of the time, it works every time.

RE: Is it possible to import sketch points from external data source (xls)

I'm not sure of your exact situation but if you have a table created wouldn't it be easier to use a "Table driven pattern" in place of going through all the steps to create a sketch and macro to create a sketch driven pattern?

ColeM CSWP

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