Access to Word - Save Word document as

[bborden]

When I save a document in Word that I have transferred from VBA to
Word I notice that the "Save As" file name is for, instance, "December
4.doc". Since the date is the first field I print on the Word
document I guess it picks up this as a key.

How do I stipulate what the name of the document is to be once I want
to save it in Word?

" .SaveAs" actually saves the document and I want to view and edit the
document and manually save it.

It would be nice to have the document save as "C:\MyProgram\Documents"
& LastName & FirstName & Date & ".doc" .

Thanks

[Joe Black]

"bborden" <bb*******@gmail.com> wrote in message
news:ea**************************@posting.google.c om...

When I save a document in Word that I have transferred from VBA to
Word I notice that the "Save As" file name is for, instance, "December
4.doc". Since the date is the first field I print on the Word
document I guess it picks up this as a key.

How do I stipulate what the name of the document is to be once I want
to save it in Word?

" .SaveAs" actually saves the document and I want to view and edit the
document and manually save it.

It would be nice to have the document save as "C:\MyProgram\Documents"
& LastName & FirstName & Date & ".doc" .

Thanks

Hi

Something like:
objWordDoc.SaveAs "C:\MyProgram\Documents\" & LastName & FirstName &
Format(Date, "d mmm yyyy") & ".doc"

Tip: use the macro recorder in Word to see how to carry out the actions you
are interested in.

Regards - Joe

[bborden51]

Thanks Joe.

[bborden51]

Thanks Joe.

[bborden51]

The only problem in doing it your way is that the document will be
saved even if you elect not to save it. It actually saves a blank page.