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