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

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
>
>