IMPORT OF BLOCK FROM AUTOCAD 2005 3

[SeanSweeney]

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

 

[bpeirson]

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.

 

[dik]

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

 

[johnwm]

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:

http://www.essexsteam.co.uk

 

[FM1]

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

 

[SeanSweeney]

Thanks chaps - WMF is a complete winner.

 

[ppata]

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

 

[PEStructural]

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.