×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Export attributes from multiple drawings to single excel/txt file

Export attributes from multiple drawings to single excel/txt file

Export attributes from multiple drawings to single excel/txt file

(OP)
I wish to export some attributes from many auto drawings into a single excel or text file - not individual files for each drawing - any ideas

Cheers
Mel

RE: Export attributes from multiple drawings to single excel/txt file

Maybe you can try next way (not tested)
At first you create the script file for example EXTR.SCR, which will extract attributes to the file for example TMP.TXT
Then you create the batch file which will start the autocad with specified drawing and will start the script file. In this batch file then you can subtract all created temporary files in to one file for example ALLINFO.TXT.

Example of batch file:
acad.exe drawing1.dwg /b extr.scr
copy allinfo.txt+tmp.txt allinfo.txt
acad.exe drawing2.dwg /b extr.scr
copy allinfo.txt+tmp.txt allinfo.txt
……

Maybe it help.

Mirekp
Mechanical and engineering calculations
http://www.mitcalc.com

RE: Export attributes from multiple drawings to single excel/txt file

Are you still looking for a way to extract attributes from your drawings into an Excel file?
If so, thanks to alot of hard work on the part of some people at VBA design forum and a lot of headaches and sweating blood I have an Excel macro program that works on what seems to be from R14 through 2004. It's written in VBA and run from Excel accessing your choice of drawings a single drawing or a complete folder. Depending on your needs it will need to be modified but should work.  Let me know if interested, I know what it's like to need something like this.

RE: Export attributes from multiple drawings to single excel/txt file

freezer;
I was searching the forum for information on extracting attributes into an excel worksheet across several dwgs and came upon you post. Please respond in the forum or at rduprey@gloverequipment.com if you are able to offer help or insight.
thanks,
sundemon

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources