How do I save a file using the value entered in a text form field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ScoJO - 23 Mar 2006 09:21 GMT

I have a word document that myself and others on my team must fill out
repeatly. I created a simple template for the basic form to automate the
process, I would like to automate the "Save As" file name using date from one
of the "Text form Fields". the file name would be
"SW_COA_XXXXXX_johnson.doc". The XXXXXX would be the numeric value entered in
Text Form Field labeled "Text 2". Can this be done?

Scott

Reply to this Message

Doug Robbins - Word MVP - 23 Mar 2006 20:10 GMT

With ActiveDocument
.SaveAs "SW_COA_" & .Formfields("Text2").Result & "_johnson.doc"
End With

I suggest that you give a more meaninful name to the bookmarks assigned to
your formfields.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have a word document that myself and others on my team must fill out
> repeatly. I created a simple template for the basic form to automate the
[quoted text clipped - 6 lines]
>
> Scott

Reply to this Message

ScoJO - 06 Apr 2006 22:07 GMT

DOUG,
Thanks for the help, it worked like a charm.

Scott Johnson

> With ActiveDocument
> .SaveAs "SW_COA_" & .Formfields("Text2").Result & "_johnson.doc"
[quoted text clipped - 13 lines]
> >
> > Scott

Reply to this Message