Automatic Document Save

[brsawvel]

Hello,

I have a vb code written that opens a word document and displays the results of a query. What is the code to cause the document, after opened and populated, to automatically save a copy into a predesignated folder - and to rewrite previous existing documents with the same name?

Predesignated folder:

 "c:\" & me.fldA

Name of document:

 & me.fldA".doc"

 

[MarkK]

A Word.Document object has a SaveAs method. Check it out in the object browser or Word VBA Help.
Simple sample...

dim wd as word.document
...opened
...populated
wd.SaveAs "c:\" & me.flda & ".doc"