Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy pieces of different word doc s
Hi,
I want to run a macro from excel where certain cells can be selected wich refer to different word documents. Depending on the language thats selected "Dutch", "German", "English" or "French", I would like to copy certain parts out of these word documents into a new document. I would bild the docs like this: [DUTCH] Loopgang ..... ..... [END] [GERMAN] Laufsteg ..... ..... [END] [ENGLISH] Walkway ..... ..... [END] [FRENCH] Passerelle ..... ..... [END] How can I if eg the language is set to FRENCH copy the section starting at [FRENCH] till the next [END]? Any help is welcome. Thanks. Lieven |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy pieces of different word doc s
this is a WORD PROGRAMMING question isn't it?
In Excel you could use SELECT CASE language CASE "ENGLISH" 'set param CASE "FRENCH" 'set param CASE .... CASE ELSE END SELECT "lieven" wrote: Hi, I want to run a macro from excel where certain cells can be selected wich refer to different word documents. Depending on the language thats selected "Dutch", "German", "English" or "French", I would like to copy certain parts out of these word documents into a new document. I would bild the docs like this: [DUTCH] Loopgang .... .... [END] [GERMAN] Laufsteg .... .... [END] [ENGLISH] Walkway .... .... [END] [FRENCH] Passerelle .... .... [END] How can I if eg the language is set to FRENCH copy the section starting at [FRENCH] till the next [END]? Any help is welcome. Thanks. Lieven |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiply # of pieces | New Users to Excel | |||
Macro to find a word and copy all rows with this word to diff ws | Excel Programming | |||
Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
Replace pieces of text | Excel Programming | |||
search for a specific word and copy the word and the preceeding words until a comma | Excel Programming |