×
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

OLE text problem

OLE text problem

OLE text problem

(OP)
Hi,
I have recently installed AutoCAD 2010 and am having problems with copying and pasting from excel.
AutoCAD 2004 worked beautifully when copying and pasting tables of text from Excel to AutoCAD, whether using 'paste' or 'paste special'.
Installed AutoCAD 2010, now when using 'paste' or 'paste special' in AutoCAD 2010, I get a 'OLE Text Size' notification. I am required to choose OLE Font, Point Size & Text Height but only the Text height can be altered.
Selecting the default (2.4694) appears to be about average.
When zooming in and out, the text size alters itself and when printing, the text size is all messed up.
Now AutoCAD 2004 is doing the same thing.
Is there a way to get around the OLE text option or turn it off altogether?
Thanks in advance.
 

My boss says 'There are no problems, only opportunites to prove yourself'.
I remain respecfully sceptical.

RE: OLE text problem

You can use the "Insert...OLE object" option from the "Insert" menu.  Then use "Properties" command to set size and plot quality.  Monochrome seems to work best for me.  Also, I have found that when opening a dwg with an embedded Excel object, the object is often scrambled IF that object is ALSO open in Excel when the dwg is opened.

RE: OLE text problem

Also, don't close Excel before saving the CAD file!

RE: OLE text problem

Is your printing done in model or paper space?

RE: OLE text problem

(OP)
Hi all,
I resolved this over the weekend; it turned out to be a very simple issue.
The excel document used font size 7.
This is not a 'normal' font size and must be summarised by AutoCAD.
AutoCAD 2010 cannot summarize it correctly for reasons I do not know.
Resizing the font in excel to 8 solved the problem completely.

Thanks to all who tried to help out.

My boss says 'There are no problems, only opportunites to prove yourself'.
I remain respecfully sceptical.

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