ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   copy pieces of different word doc s (https://www.excelbanter.com/excel-programming/434605-copy-pieces-different-word-doc-s.html)

lieven

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



Patrick Molloy[_2_]

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




All times are GMT +1. The time now is 11:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com