<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>tema Re: Dimensions from Cad to a pre-existing Excel file? en AutoCAD Forum</title>
    <link>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8526960#M964218</link>
    <description>&lt;P&gt;Just to be clear, you want to be able to select a single dimension line in AutoCAD and have the dimension value copied to a specific cell of an Excel spreadsheet?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;BTW, what is the difference between an existing Excel file and a "pre-existing" file. Did the latter exist before it existed? What does that mean?&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 16 Jan 2019 15:54:39 GMT</pubDate>
    <dc:creator>leeminardi</dc:creator>
    <dc:date>2019-01-16T15:54:39Z</dc:date>
    <item>
      <title>Dimensions from Cad to a pre-existing Excel file?</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8526736#M964209</link>
      <description>&lt;P&gt;If I can get as close as possible that would be awesome!&lt;/P&gt;
&lt;P&gt;Is there a lisp and/or way to transfer dimension text&amp;nbsp;to a specific cell in a pre-existing Excel template instead of it creating a new book each time?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;Thanks!&lt;/P&gt;</description>
      <pubDate>Wed, 16 Jan 2019 14:47:37 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8526736#M964209</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2019-01-16T14:47:37Z</dc:date>
    </item>
    <item>
      <title>Re: Dimensions from Cad to a pre-existing Excel file?</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8526960#M964218</link>
      <description>&lt;P&gt;Just to be clear, you want to be able to select a single dimension line in AutoCAD and have the dimension value copied to a specific cell of an Excel spreadsheet?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;BTW, what is the difference between an existing Excel file and a "pre-existing" file. Did the latter exist before it existed? What does that mean?&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 16 Jan 2019 15:54:39 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8526960#M964218</guid>
      <dc:creator>leeminardi</dc:creator>
      <dc:date>2019-01-16T15:54:39Z</dc:date>
    </item>
    <item>
      <title>Re: Dimensions from Cad to a pre-existing Excel file?</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8526983#M964219</link>
      <description>That would be interesting, but no, I meant existing, and yes that is the&lt;BR /&gt;gist of it.&lt;BR /&gt;</description>
      <pubDate>Wed, 16 Jan 2019 15:59:49 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8526983#M964219</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2019-01-16T15:59:49Z</dc:date>
    </item>
    <item>
      <title>Re: Dimensions from Cad to a pre-existing Excel file?</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8527077#M964223</link>
      <description>&lt;P&gt;Would the following be acceptable?&lt;/P&gt;
&lt;P&gt;1. The user selects a dimension line in AutoCAD, gives a command and a text file is automatically created.&amp;nbsp;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;2.&amp;nbsp; A VBA macro is run in an open Excel file and the text file is referenced and the dim value is placed in the selected cell.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;This processed could be enhanced such that the user is prompted for a cell address when giving the command in AutoCAD and then referenced when the macro is run in Excel.&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 16 Jan 2019 16:21:50 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8527077#M964223</guid>
      <dc:creator>leeminardi</dc:creator>
      <dc:date>2019-01-16T16:21:50Z</dc:date>
    </item>
    <item>
      <title>Re: Dimensions from Cad to a pre-existing Excel file?</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8527215#M964229</link>
      <description>That sounds great! Just to be clear, however, this can be used for multiple&lt;BR /&gt;dimensions at one correct?&lt;BR /&gt;</description>
      <pubDate>Wed, 16 Jan 2019 16:56:49 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8527215#M964229</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2019-01-16T16:56:49Z</dc:date>
    </item>
    <item>
      <title>Re: Dimensions from Cad to a pre-existing Excel file?</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8527257#M964233</link>
      <description>&lt;P&gt;Please be more specific about how to handle multiple dimensions.&amp;nbsp; For example:&lt;/P&gt;
&lt;P&gt;Pla A&lt;/P&gt;
&lt;P&gt;1. User selects several dimensions, gives command.&lt;/P&gt;
&lt;P&gt;2. In Excel all the dimension values are place in one cell.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;or&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Plan B&lt;/P&gt;
&lt;P&gt;1. User selects several dimensions, gives command.&lt;/P&gt;
&lt;P&gt;2. In Excel&amp;nbsp;the first&amp;nbsp;dimension value is placed in the selected&amp;nbsp; cell and other values&amp;nbsp; successively in cells below it.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;or&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Plan C&lt;/P&gt;
&lt;P&gt;1. User gives command and then is prompted to select a dimension line then asked for a cell number, the process is repeated until the user indicates he/she is done.&lt;/P&gt;
&lt;P&gt;2. In Excel the dimensions are placed in their respective cells.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;or something else?&lt;/P&gt;</description>
      <pubDate>Wed, 16 Jan 2019 17:06:32 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8527257#M964233</guid>
      <dc:creator>leeminardi</dc:creator>
      <dc:date>2019-01-16T17:06:32Z</dc:date>
    </item>
    <item>
      <title>Re: Dimensions from Cad to a pre-existing Excel file?</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8527716#M964278</link>
      <description>Plan B would be perfect thank you!&lt;BR /&gt;</description>
      <pubDate>Wed, 16 Jan 2019 19:27:49 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8527716#M964278</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2019-01-16T19:27:49Z</dc:date>
    </item>
    <item>
      <title>Re: Dimensions from Cad to a pre-existing Excel file?</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8528081#M964290</link>
      <description>&lt;P&gt;The following vlisp program creates a CSV file of the values of selected dimension lines.&amp;nbsp; It can be directly opened by Excel and then copy and pasted to wherever you wish.&lt;/P&gt;
&lt;PRE&gt;(defun c:getdims (/ fn)
					; create a csv file of selected dimension lines.
					; LRM 1/16/2019
					;  
  (setq f (getfiled "Create Output File" "" "csv" 1))
  (setq fn (open f "w"))
  (if (setq ss (ssget '((0 . "DIMENSION"))))
    (progn
      (setq i 0)
      (while (setq en (ssname ss i))
	(setq ed (entget en))
	(setq dv (cdr (assoc 42 ed)))
	(if (= (cdr (assoc 70 ed)) 34)	; check if angular dim
	  (setq dv (/ (* dv 180) 3.xxx-xxxxxxxx))
	)
	(write-line (rtos dv) fn)

	(setq i	(1+ i)
	)				; end setq i
      )					;end while
    )					; end progn
  )					;end if
  (close fn)
  (princ "\n File ") (princ f) (princ " created.")
  (princ)
)
&lt;/PRE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 16 Jan 2019 21:30:58 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8528081#M964290</guid>
      <dc:creator>leeminardi</dc:creator>
      <dc:date>2019-01-16T21:30:58Z</dc:date>
    </item>
    <item>
      <title>Re: Dimensions from Cad to a pre-existing Excel file?</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8528139#M964294</link>
      <description>That's awesome! Thank you so much!&lt;BR /&gt;</description>
      <pubDate>Wed, 16 Jan 2019 21:50:49 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8528139#M964294</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2019-01-16T21:50:49Z</dc:date>
    </item>
    <item>
      <title>Re: Dimensions from Cad to a pre-existing Excel file?</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8528257#M964299</link>
      <description>&lt;P&gt;You are welcome.&lt;/P&gt;
&lt;P&gt;Somehow the line in the code above :&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;  (setq dv (/ (* dv 180) 3.xxx-xxxxxxxx))&lt;/PRE&gt;
&lt;P&gt;was not what I copied into my post.&amp;nbsp; That line should read:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;(setq dv (/ (* dv 180) 3.xxx-xxxxxxxx))&lt;/P&gt;
&lt;P&gt;It converts the angle value from radians to degrees.&amp;nbsp; The code in the attached program GetDims.lsp is correct.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 16 Jan 2019 22:30:27 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8528257#M964299</guid>
      <dc:creator>leeminardi</dc:creator>
      <dc:date>2019-01-16T22:30:27Z</dc:date>
    </item>
    <item>
      <title>Re: Dimensions from Cad to a pre-existing Excel file?</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8529241#M964345</link>
      <description>&lt;P&gt;&lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/822616"&gt;@leeminardi&lt;/a&gt;, if you post a number that's a certain amount of digits long, the forums will automatically replace it with xxxxx as it is the length of the Autodesk activation key (or maybe license number, I can't remember). it's to stop people posting registration information but it works on any number with that many digits.&lt;/P&gt;</description>
      <pubDate>Thu, 17 Jan 2019 10:25:29 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8529241#M964345</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2019-01-17T10:25:29Z</dc:date>
    </item>
    <item>
      <title>Re: Dimensions from Cad to a pre-existing Excel file?</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8529996#M964376</link>
      <description>&lt;P&gt;Thanks&amp;nbsp;@Anonymous&lt;/a&gt;, I did not know that the forum software did that.&amp;nbsp; It would have driven me nuts to figure out what was going on.&amp;nbsp; Thanks for saving my sanity!&lt;/P&gt;</description>
      <pubDate>Thu, 17 Jan 2019 14:48:07 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/dimensions-from-cad-to-a-pre-existing-excel-file/m-p/8529996#M964376</guid>
      <dc:creator>leeminardi</dc:creator>
      <dc:date>2019-01-17T14:48:07Z</dc:date>
    </item>
  </channel>
</rss>

