Search code examples
exceloleautocadvba

How can I set a default value to the x and y dimensions of a copied object from excel into autocad?


I would like to set a value for the default size of the OLE object when I copy and paste a range of cells into autocad from excel.

Normally, when I copy and paste from excel into autocad, in autocad, i have to mess with the scaling to get it just right. This takes unnecessary time.

Instead, I want excel to paste this range of cells at a certain height and width. I'm curious if there are properties in excel or autocad where I can set the default x and y dimensions of the copied object.

(This is the object copied into autocad) The area in blue is what i want to preset a height and width for.

The range of cells to be copied in excel are always the same, but it just will have different data in it each job. It's the area highlighted in gray.


Solution

  • You can't do that on-the-fly unless you made yourself a sophisticated lisp. For me I do all the adjustments I need on one ole object only (either scaling or aligning it to a line or a rectangle). I copy this object multiple times in the drawing then I edit these copies (OLE > OPEN) by copying the ranges I need from Excel into them.

    enter image description here