+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Super Member
    Using
    not specified
    Join Date
    Feb 2006
    Posts
    527

    Default Exporting Attributes to an excel Spread Sheet using AutoCAD 2008 VBA

    Registered forum members do not see this ad.

    Subject: Exporting Attributes to a Spread Sheet using AutoCAD 2008 VBA

    How can someone export a attribute to an excel spread sheet in AutoCAD
    2008 VBA and put it in a piticular column? I am thinking about making a
    batch routine that would read a file with a group of dwg file names. It
    would then look at an attributed block in those drawings and export a
    piticular attribute to an excel spread sheet. I could direct it to a piticular
    colume for a list of exported attributed data. Since it is a batch routine
    it could be in a excel colume. Example a list of title names.
    Maybe there is an easy way to do that in AutoCAD without programming?
    If so, I would like to know.
    If not, first step I need to know is how to export an attribute to excel spread sheet in CAD.
    VBA.
    Thank you,

  2. #2
    Senior Member
    Using
    AutoCAD 2008
    Join Date
    Nov 2005
    Location
    Bulgaria, Sofia
    Posts
    228

    Default

    Why don't you use the Tools--> Attribute Extraction and thus extract all the blocks with attributes from a drawing. Then you can use a filter in Excel and get only the blocks you need. Of course it is possible to write a VBA or Lisp to do this if you need something more specific.

  3. #3
    Super Member rustysilo's Avatar
    Computer Details
    rustysilo's Computer Details
    Operating System:
    WinXP
    Discipline
    Civil
    rustysilo's Discipline Details
    Occupation
    Senior CAD Draftsman
    Discipline
    Civil
    Using
    Civil 3D 2008
    Join Date
    Jul 2007
    Location
    Jacksonville, FL - USA
    Posts
    1,458

    Default

    Registered forum members do not see this ad.

    Joro's got it. If you need help with attribute extraction it is explained fairly well in the help file.
    "Constantly choosing the lesser of two evils is still choosing evil." ~ Jerry Garcia
    flickr |
    work | blog | creed
    rustysilo's tips & tutorials

Similar Threads

  1. controlling titleblock attributes with excel sheet
    By comcu in forum AutoLISP, Visual LISP & DCL
    Replies: 2
    Last Post: 20th Aug 2007, 10:14 pm
  2. exporting attributes to excel
    By comcu in forum AutoCAD Drawing Management & Output
    Replies: 2
    Last Post: 25th Jun 2007, 08:32 pm
  3. Send attributes to specific Excel sheet
    By kclanton in forum AutoLISP, Visual LISP & DCL
    Replies: 11
    Last Post: 4th Apr 2007, 12:26 am
  4. how do i create points from excel spread sheets
    By yiyan in forum AutoCAD Beginners' Area
    Replies: 4
    Last Post: 7th Jan 2007, 12:00 am
  5. dimensions to a XL spread sheet
    By tcclegg in forum AutoCAD Drawing Management & Output
    Replies: 2
    Last Post: 1st Aug 2006, 09:23 am

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts