Create and Save a new word document from user form

[rob_h]

Hello once again,

This project is creating a database in Excel and then opening a Word Template to paste data. I am using Excel to track Engineering Change Requests, the Word document is then a paper copy of each request and related information from the user form.

So far I have the code opening the word template working, it's trying to SaveAs I've not got worked out. This is a little tricky (for me at least) in that I am giving the file path of where to save, then literal text "ECR-" and concatenate the value of a text box on the user form.

The result I am after is: ECR-1003, where 1003 is the auto-assigned number for the record that is in the user form textbox. The text box is Locked to prevent accidental changes.

The code here is what I have. Just haven't quite got the save as syntax right.

Thank you in advance for any assistance.

Please Login or Register  to view this content.

[Tinbendr]

Try this

Please Login or Register  to view this content.

I always add the extension, too.

Please Login or Register  to view this content.

[rob_h]

Thanks Tinbendr, I'll give it a go after awhile.

Not sure what the ",51" is doing but it will be interesting to find out.

[Tinbendr]

You can define what word file format to save it as. 51 means the default setting.

[rob_h]

Tinbendr,

Your suggestion makes the process work. I'm guessing this is a version specific issue but I had to use the .SaveAs and not include the , 51 to make it work on my system. I am still stuck on 2007 versions of MS Office until I upgrade.

Now that this is working I can continue adding code to actually move data into the Word document.

My guess is that I will be back with questions about that!

For a second time, at least, you have gotten me on the right path.

Thank You