macro command button, save and print and clear

[fatboy1973]

Hi all,


I am a total newbie and try to ascertain if it is possible to insert a command button in a word document called "Print and Save" if that is what I need.

I have constructed a word doc for a report that I require different staff to complete at different times, mainly all check boxes to show if something has been done and a couple of text boxes.

The actions upon clicking the command button would be to:


Print the document


Save a version, ideally auto numbering to next in sequence,
save to a designated folder
clearing the fillable form that it is on so a fresh report can be done


Any help in me achieving this would be very highly appreciated.


Thanks in advance

[gmayor]

The attached template will do that. Open it and change the path and the default filename as required currently

    strPath = Environ("USERPROFILE") & Chr(92) & "Documents\"
    strName = "MyForm_"

and put your form where the fixed text is (leaving the ID field). The ID is incremented each time you create a new document from the template from the number in the ID field.

Create a new document from the template for each new form.

Click the button on the ribbon to save and print the document.

You will need the CustomUI Editor to change the ribbon labels. http://gregmaxey.mvps.org/word_tip_p...bbon_main.html

[fatboy1973]

thanks for this, is it possible for a button command for the print, save and clear element, ideally I would like to use this form on a tablet for the reports to be completed

Thanks again and your time is appreciated

[gmayor]

Not without knowing what the form contains to be cleared. The form will always be cleared when you create a new document from the template which is the correct way to use a template.

As for the use on a tablet ... what sort of tablet? I am not sure how such a template or macros generally work on the non-Windows version of Word.

[Charles Kenyon]

Tablet version cannot use macros, AFAIK.

Cross-posted at: https://answers.microsoft.com/en-us/...d-697a4df69668
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184