Command Button to Save Userform with dynamic name

Hello,
I have UserForm: frmQA911 with ComboBox19: (last name, first name) and Textbox10: =TODAY()

I would like to save the form to a specific folder on the desktop ("Quality Assurance") as the following name: Smith, John_911_7/20/2014. This way, when the value in ComboBox19 and/or the date changes, a new file will be added to that folder.

Can anyone help?

If it can also be converted to a PDF, even better.

Can anyone assist with this?

Can I convert a UserForm to some saveable file? PDF or otherwise?

Please Login or Register  to view this content.

That is the code for the UserForm. What could I add to this to either save it as a PDF or save it to a Word Document? It is an Evaluation, and I would like to be able to go back and review it down the road. There will literally be hundreds of these completed.

Please Login or Register  to view this content.

I snatched this from another site where the author was trying to accomplish the same thing. By this point, he was able to do nearly everything, but he did encounter an issue when clicking the button; it had to do with the ".ActiveDocument.SaveAs Filename:=SaveAsName" line. He apparently resolved it but never posted the final product, and the post is back from 2007. Anyone willing to help combine what I have posted with this code so that I could get a workable file?

Possibly, but I am concerned about the amount of data that would require. There will, literally, be hundreds of these forms submitted a year, and saving all of them as images could take up a lot of space.

At the moment and after all of the time I have dedicated to this project, I am willing to go any route to accomplish what i need.

This is an employee database. The UserForms i want to save are evaluations. I would like to be able to access completed forms in the future (as PDF or whatever other method of saving them). We have hundreds of employees, and at minimum, 1 of these will be done/month for each employee.

So, to answer your question....I'll take what i can get for now.

Transferring it to a worksheet is a last resort. I'm not proficient, I'm not getting the desired appearance, and I spent a considerable amount of time designing the form. But, if it's the only way, so be it. I won't be able to try for a day or 2. Regardless, thanks for your help!!

Please Login or Register  to view this content.

Thanks for the help. I tried it in the above code, but I received a compile error in the keybd_event section. I attached this to a Command Button, so perhaps that is causing the issue. Can anyone assist?

I would love to, but apparently the file is too large.

Apparently, I was wrong.

Attached is the workbook. The form I am specifically working on (for this issue among a plethora of others) is the QA911 form PRINT button.

Be nice. I am a complete novice and am piecing things together as I go.

If I could get this to work perfectly, one click of a Command Button would save a copy of this Form into a specific folder (based upon the person that the QA is being completed) AND print the form so it could be signed and sent up the Chain of Command.

Jaslake,
Thanks...
I may pick your brain for a few other things then....

I realize that the multi-page will be an issue, but there was no way around it unfortunately. I expected to put some type of message box alerting the user to print both pages of the form, but as you can tell, I have yet to tackle that. I don't mind separate buttons. The issue I ran into was that I boxes to go blank when the form is submitted, so it was impossible to print after submission. I'll take any solution I can find

Jaslake,
Thank you so much! When I try to print it though, I notice it is cutting off the right side of the form. It looks as if you made the form a bit narrower. Do I have to do that in order for the entire form to fit completely or is there a way to adjust the margins?

And not to look a gift horse in the mouth, but is there a way to do it so that the toolbar at the bottom is not showing?

I'll check. You are really awesome. Thanks!

For the Print code, I get a Sub or Function not defined error for the Keybd_event. That was the same issue I was having before.

For the both codes, I get a Sub or Function not defined error for the Keybd_event. That was the same issue I was having before.