Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export attributes from multiple drawings to single excel/txt file 1

Status
Not open for further replies.

CadDraftee

Mechanical
Joined
Sep 16, 2003
Messages
48
Location
AU
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
 
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
 
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.
 
freezer, I would be glad to try it out, it sounds great.

jpeterson@wba-arch.com
or
2singapore@go.com


 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top