Hi everybody,

There must be a way in a VBA to create 3 new files: A.doc, B.doc, C.doc from one original file: original.doc. The content of the 3 new files would have the content of the original.doc (with a copy/paste, I guess).



However, I do not know how to do that in a VBA. Someone can help me on this?

Michael

Hi Michael,

Simply use the SaveAs method three times, giving the file a new name each time.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul,

I should admit after all that my problem is a bit more complicated than what I explained in the previous post. In the joined file, I have 4 different bulletins for three locations. The first page of the page corresponds to the the original document while the next pages represent the result that I wish to get in 3 distinct documents. You will notice that some parts of the original document are not copied in the 3 sub-documents.

Of course, the sample in example is simple. In reality, the original document that I receive every month has about 150 pages and it includes 11 locations.

Thanks for your help

Michael

Attached Files

FQCN13 CWHX 100000.doc (41.0 KB, 8 views)

Hi Michael,

It's not just 'a bit more complicated', it's a great deal more complicated - especially when you get to the 'REMAINDER UNCHANGED' part.

What it seems you'll need is an array in which to hold each of the 11? location names, string variables to hold the most recent data for each location, another set of string variables to hold the accumulated data for each location, some 'Find' logic to identify each bulletin and, having done so, to retrieve the bulltetin ID and to update the variables for each of the locations referred to in it. This needs to be repeated for all bulletins, after which, a document for each location can be created and saved. This is no trivial task!

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]