×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

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!

*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

IMPORT OF BLOCK FROM AUTOCAD 2005
3

IMPORT OF BLOCK FROM AUTOCAD 2005

IMPORT OF BLOCK FROM AUTOCAD 2005

(OP)
I HAVE A TITLE BLOCK IN AUTOCAD WHICH I WOULD LIKE TO HAVE IN EXCEL (FOR PRESENTATION PURPOSES) BUT NOT ACTIVE - A PICTURE OF IT I GUESS.

I HAVE TRIED SPECIAL PASTING BUT IT IS EITHER TO SMALL OR THE QUALITY IS LOST. ANY IDEAS. THANKS

RE: IMPORT OF BLOCK FROM AUTOCAD 2005

Try plotting as a JPG. In AutoCAD 2002 from the plot menu on the Device tab choose PublishToWeb JPG.pc3 as the plot device. You can specify the folder the JPG is saved in on the same tab (lower right where you will also enter the name). You can set the plot parameters so only the area you choose will be saved in the JPG, just like plotting to a plotter.

In Excel choose insert->picture->from file then find your picture.

RE: IMPORT OF BLOCK FROM AUTOCAD 2005

I haven't tried it in excel, but for programming in Delphi, I often export autocad drawings as *.wmf (windows meta files) and they work well without the graphics 'jaggies'issues.

Dik

RE: IMPORT OF BLOCK FROM AUTOCAD 2005

You can paste WMFs and resize them in Excel

Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting

Steam Engine enthusiasts: www.essexsteam.co.uk

RE: IMPORT OF BLOCK FROM AUTOCAD 2005

I do this often with sketches in my calc sheets,
as johnwm said, in autocad, under "File" click "export" chose your item(s) and save as wmf file
in your excel file insert as picture from file and crop and resize
resize from corners so the original aspect ratio is maintained
I hope this helps

RE: IMPORT OF BLOCK FROM AUTOCAD 2005

(OP)
Thanks chaps - WMF is a complete winner.

RE: IMPORT OF BLOCK FROM AUTOCAD 2005

If you are interested to have the images just for presentations, click Alt+Print Scrn, open the image from clipboard with any image viewer and save it.
 Good luck

Best regards,
Andrei

RE: IMPORT OF BLOCK FROM AUTOCAD 2005

A quick way is to just select the element in AutoCAD and go to Edit>Copy and then go into Excel and Edit>Paste.  If the background in the pasted image in excel is not white, go back into AutoCAD and type in the command wmfbkgnd and set it to off.  Then repeat the above procedure.  This works well for me.

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! Already a Member? Login



News


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close