TEXT OUT OF ALL DRAWINGS- Example 1

A - SINGLE DRAWING OPERATION

1. LOAD THE MACRO

2. OPEN THE DRAWING COPY IN A NEW DIRECTORY

3. RUN MACRO: TEXT OUT OF ONE DRAWING

4. COPY TEXT FROM THE FIRST  TO THE  SECOND SHEET OF EXCEL FILE AND SAVE FILE AS TRANSLATE.XLS

5.COPY TEXT TO ANY ONLINE TRANSLATION PROGRAM TO TRANSLATE THE TEXT INTTO ANY LANGUAGE

6. PASTE THE TRANSLATION INTO EXCEL COLUMN AFTER THE ORIGINAL TEXT

7. RUN MACRO: TRANSLATE ONE DRAWING

8. SAVE THE TRANSLATED DRAWING

B - BATCH OPERATION ON ALL DRAWINGS IN THE DIRECTORY

1. LOAD THE MACRO

wpe1F.jpg (150059 bytes)

2. OPEN ANY ONE DRAWING TO DEFINE THE DIRECTORY OF ACTION

wpe23.jpg (16797 bytes)

3. RUN MACRO: TEXT OUT OF ALL DRAWINGS

wpe20.jpg (204989 bytes)

4. COPY TEXT FROM THE FIRST TO THE SECOND SHEET OF EXCEL FILE AND SAVE FILE AS TRANSLATE.XLS

4a. SORT TEXT AND ELIMINATE DUPLICATES (HELPS SPEED)

5.COPY TEXT TO ANY ONLINE TRANSLATION PROGRAM TO TRANSLATE THE TEXT INTTO ANY LANGUAGE

 

 

6. PASTE THE TRANSLATION INTO EXCEL COLUMN AFTER THE ORIGINAL TEXT

7. RUN MACRO: TRANSLATE ALL DRAWINGS

wpe5.jpg (16686 bytes)

8. STAND BACK AND WATCH AS EACH DRAWING OPENS, GETS TRANSLATED AND IS SAVED.

9. IF NUMBER OF DRAWINGS TO BE TRANSLATED IS ABOVE THOUSAND OR SO, START THE MACRO IN THE EVENING AND COME BACK IN THE MORNING TO SEE THE TRANSLATED DRAWINGS.

ORIGINAL DRAWING IN ENGLISH

wpe2.jpg (98922 bytes)

TRANSLATION INTO PORTUGUESE

GERMAN

wpe1.jpg (133291 bytes)

FRENCH

wpe2.jpg (134371 bytes)

ITALIAN

wpe3.jpg (134173 bytes)

SPANISH

wpe5.jpg (133681 bytes)

EXCEL SHEET INTO WHICH DWG TEXT IS EXPORTED AND TRANSLATIONS  PREPARED

wpe21.jpg (217580 bytes)