Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,298
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
multiply # of pieces Mike Stewart New Users to Excel 6 March 8th 09 12:04 AM
Macro to find a word and copy all rows with this word to diff ws Chas Excel Programming 3 April 27th 07 11:16 PM
Copy from Word to Excel, and retain indent, plus word wrap Eric Excel Discussion (Misc queries) 1 March 9th 07 03:15 AM
Replace pieces of text Swn-Y-Mor Excel Programming 3 March 1st 06 02:04 PM
search for a specific word and copy the word and the preceeding words until a comma DHANANJAY Excel Programming 12 December 31st 05 12:53 PM


All times are GMT +1. The time now is 12:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"