REASON AND CONCEPT FOR AUTOCAD INTEGRATION WITH EXCEL To Edit, Revise or Translate text in all drawings of a Directory at one go The concept is to manipulate text of hundreds of drawings on one Excel sheet where it is easier to search, sort, compare edit and even translate into other languages. The tools needed for this purpose are: (a) a macro to extract text of all drawings into Excel and (b) a macro to replace all instances of certain texts with an equivalent as listed in the same Excel sheet. For additional information, please contact me. [email protected] |
| Marketing Partners Needed | Business Ideas | FAQA - Frequently Asked Questions- Answers | Links to ACAD related sites |
| DESCRIPTON | COST | DOWNLOAD | ||||||||||||
| MACROS BASED ON AUTOCAD INTEGRATION WITH EXCEL | ||||||||||||||
| 1 | . | Text out of all drawings into one Excel sheet - VBA Macro (textout.vba 350 kB) | FREE | textout.vba | ||||||||||
| . | . | Example for AutoCAD users: You load the macro into AutoCAD2000 by Menu + Tools + Macros. You run it by Macros+Run+Textout to export all text in all the drawings of the current directory into an Excel sheet. There you can sort the text and check for uniformity, spelling, etc. In excel you can use seach method to find which text exists in which drawings. I am offering the TextOut macro free with the anticipation, you will like it so much and later buy the translation macro below. Example: textout and translate macros used on Acad\samples\Wilhome.dwg | ||||||||||||
| . | . | LOAD THE TEXTOUT MACRO | RUN THE MACRO | TEXT FLOWS INTO EXCEL | LOAD THE TRANSLATE MACRO | DRAWING IN ENGLISH | ||||||||
| . | . | PORTUGUESE | GERMAN | FRENCH | ITALIAN | SPANISH | ||||||||
| . | . | SAMPLE DRAWING IN ALL SIX LANGUAGES (This will be a bit slow. Avoid) |
Excel Sheet for translation into all five languages | |||||||||||
| 2 | . | Text (Translation or correction) from Excel sheet into all drawings - VBA Macro (translate.vba 350 kB) | $1000.- | ORDER | ||||||||||
| . | . | Example for AutoCAD users: EXPO98 MAPS.dwg (From AutoCAD\Samples\) ORIGINAL dwg in PORTUGUESE and Translations into 5 languages, made in AutoCAD2000. TEXTOUT extractS the drawing text into Excel. You copy/paste it into e.g. www.Babelfish.com and copy/paste the machine translation back into Excel. TRANSLATE replaces text in all drawings with translation. If you notice any funny translations, just note that I pasted the machine translation as-is. You can edit text in Excel before running the Translate macro. In time, you build up in Excel sheet the text you often need for translation of drawings and use it for any number of drawings to come. see the results: | . | . | ||||||||||
| . | . | PORTUGUESE | ENGLISH | FRENCH | SPANISH | GERMAN | . | . | ||||||
| . | . | SAMPLE DRAWING IN ALL FIVE LANGUAGES (This will be a bit slow. Avoid) | . | . | ||||||||||
| . | . | My Idea of safety against code surprizes - Post any bad experience in a
certain Independent Bulletin Board where others too can look up by subject: BEWARE SOFTWARE BITES - name. news://discussion.autodesk.com/pn.classifieds |
. | . | ||||||||||
| . | . | My Idea of Payment Model - Choose between either posting a complain
for all to see or just pay. If disappointed, post complaint on independent Bulletin Board. Before ordering, see if others have complained. news://discussion.autodesk.com/pn.classifieds Pay only if satisfied. |
. | . | ||||||||||
| . | ||||||||||||||
| AUTOLISP MACROS FOR AUTOCAD | . | |||||||||||||
| 1 | Join Lines into PLine for all On-Layers at one go | FREE | . | |||||||||||
| 2 | Rotate drawing to horizontal before plotting | FREE | ||||||||||||
| 3 | Make texts into Attributes before blocking | FREE | . | |||||||||||
| All autolisp macros are in one file - Samurai01.fas (3 kB) | FREE | samurai01.fas | ||||||||||||
| . | ||||||||||||||
| FREQUENTLY ASKED QUESTIONS AND ANSWERS | ||||||||||||||
| How to install and run VBA macros | . | |||||||||||||
| How to install and run Autolisp Macros | . | |||||||||||||
| MARKETING PARTNERS NEEDED | ||||||||||||||
| 1 | I am looking for marketing partners to distribute the above described translation macro. If you are interested, you may proceed with test trials even without contacting me. If your client has questions, you may pass them to me and I will add them to the Frequently Asked Questions and Answers here. If you secure an order for the program, you e-mail me and I deliver it as e-mail attachment directly to your client. Your first client is to pay the whole sum into your account. Your second client pays into my account. This is the sum total of my finance model. Any shopkeeper would sound more sophisticated, I know. Each macro delivered will be client-specific, with client's name and password, as my only attempt at safeguarding my interests. I think this is as fair as fair goes. | |||||||||||||
| LINKS TO AUTOCAD RELATED SITES | ||||||||||||||
| http://www.opendwg.org forum and information around format of DWG files, applications for errands on a computer without AutoCAD, like conversion of DXF to/from DWG, and many more. Very interesting. | ||||||||||||||
| http://www.i5ive.com/discussions.cfm/autocad | ||||||||||||||
| Newsgroups available under autodesk.autocad | ||||||||||||||
| An AutoCAD 2000 Resource Guide | ||||||||||||||
| Programs | ||||||||||||||
| HOME | ||||||||||||||
| Eng-Tips | ||||||||||||||
| Topics | ||||||||||||||
