Stripping userform textbox field to name document

[Anthony904]

Current-
I have a word 97 template (dot) that users open to fill in data. Data is entered with the use of userforms. When a user opens up the template the document is named "Document1". User completes the form and clicks save as, names the document and stores it in a shared folder.

What I want-
I would like to automate the naming of the document.

Example: When a user opens the blank template they are instructed to fill in what Product A and what Product B is (on the userform). I would like to strip what the users entered in those two fields and name it as the new document. (ie.. "ProductA_to_ProductB.doc")

I do have a shared folder that these .doc are to be stored if needed.

I'm open to any other ways of doing this.

Thanks!

 

[SkipVought]

Sounds peachy to me?

Is this a question related to WHAT or HOW?

Skip,
[sub]
[red][/red]
[/sub]

 

[Anthony904]

More how..

 

[SkipVought]

Well can you post the code for your way, so we might have a stab at, "...other ways of doing this."

Skip,
[sub]
[red][/red]
[/sub]

 

[mintjulep]

Something along the lines of:

myDocument_full_path = "ThePath\where\I\want\TheFile\" & Product_A.Value & "_to_" & Product_B.Value & ".doc"
ActiveDocument.SaveAs FileName:=MyDocument_full_path

 

[mintjulep]

And you might want to activedocument.attachedtemplate = "" before you save.

 

[fumei]

mintjulep - "you might want to activedocument.attachedtemplate = "" before you save."

Why are you suggesting that?

Gerry
My paintings and sculpture

 

[mintjulep]

Setting the attachedtemplate to null prevents Word from trying to open a reference to the original template anytime the created document is opened in the future.

If you don't, Word will try to find a way to open the reference, which can delay the opening of the document until a way is either found, or Word gives up.

Not a problem if the template is local, or on a fast network, but if are working on a laptop, WiFi in some hotel or Starbucks, with VPN back to the office, it can really slow things down.