×
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

Autocad OLE feature

Autocad OLE feature

Autocad OLE feature

(OP)
a drill plan of a PC board is developed in acad 2004.  To locate the holes with X's and Y's, I do a listing and copy this listing to clipboard. I invoke the OLE object command from the insert pull down menu and select MS excel worksheet from object type as well as selecting create new; then I paste from clipboard the entire history of the hole locations.  I want to clean this history before copy to and paste from clipboard when returning to the autocad drawing screen.  The clean process is tedious and time consuming and the Excel program does not lend itself to be efficiently used such as erasing rows and columns of unwanted information.  Does anybody have any suggestion?

RE: Autocad OLE feature

>Does anybody have any suggestion?

Yes... fairly simple.

It involves using a unit block for your hole(s), exporting the X & Y locations (insertion points) via EATTEXT directly to an XLS sheet. And then copy/pasting that back into AutoCAD as %Product Entities vs an OLE Object.

or use a product like AutoCAD Mechanical, Mechanical Desktop or Inventor that automates the hole chart creation process.

- Tracy

RE: Autocad OLE feature

(OP)
thanks tracy

RE: Autocad OLE feature

(OP)
Tracy--tried your procedure and I realized that since this board has 320 holes ,I would have to turned each hole into a block with the insertion points at the centers of the holes.  EATTEXT will list the insertion coordinates of the blocks but the coordinates are based on the UCS world position and not based on a UCS new origin which would be a corner of the board.
So far doing a history of the holes and pasting on word or note pad for editing purposes and then pasting back to autocad seems to be faster.
Am I missing something w/ your suggestion?

RE: Autocad OLE feature

Sorry I assumed the origin of the pc board was at 0,0...

You can XREF the board layout into a new drawing, move the xref from the corner to 0,0... BIND > INSERT and then run EATTEXT.

BTW you can export directly to an XLS or MDB from EATTEXT

- Tracy

RE: Autocad OLE feature

(OP)
will try it-thanks!!

RE: Autocad OLE feature

One last thought...

Why not simply export the block's insertion points (EATTEXT) to an XLS file directly.  Then create two additional columns and simply deduct the differeence in the X & Y distance of the parts UCS vs. WCS?

Or move the part so the origin is 0,0,0 in the WCS?

- Tracy

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