home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!olivea!decwrl!csus.edu!csusac!cindy!psmedsha
- From: psmedsha@ecst.csuchico.edu (Paul Smedshammer)
- Newsgroups: alt.cad.autocad
- Subject: AutoCAD for Windows to Excel
- Keywords: Spreadsheet
- Message-ID: <1992Jul22.200140.23501@ecst.csuchico.edu>
- Date: 22 Jul 92 20:01:40 GMT
- Sender: news@ecst.csuchico.edu (no news is good news)
- Organization: California State University, Chico
- Lines: 28
- Nntp-Posting-Host: cscihp.ecst.csuchico.edu
-
- Hello. This is my first question in this group. I hope that this is an
- appropriate post in this group.
-
- My problem is that my boss would like to use AutoCAD for Windows to
- link to an Excel spreadsheet. What we would like to do is create a drawing
- using blocks and then export the number of certain blocks used to Excel in
- order to create an estimate of the drawing. Lets say that I was making a
- drawing of a sprinkler system. I would have already created blocks for
- different fittings, sprinklers, and pipe. Now after the drawing is finished
- I would like to export the total number of fittings A, total number of
- fittings B, total number of sprinklers, and the total number of Pipe blocks
- used.
- I have exported the drawings using DDE but it doesn't seem to be in a
- usable format. Especially if it is a rather large drawing I will get a very
- large listing of elements with information that I don't need. All I would
- like is the number of individual block types used.
- I know this must be possible because I saw the same sort of thing in
- an add for AutoCAD for Windows. Is there an easy way to do this or a book
- that I could buy that had this information in it? If I just had one example
- I could accomplish our desired task. Thanks for any help you can give us.
-
-
- ------------------------------------------------------------------------------
- psmedsha@ecst.csuchico.edu (Paul Smedshammer)
-
- Graduate Student in Mechanical Engineering
- California State University at Chico
- ------------------------------------------------------------------------------
-