macro command button, save and print and clear

gmayor · #1 07-06-2017, 05:48 AM

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

Code:

    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 · #2 07-06-2017, 06:03 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Newbie Wants to Add Print Command Button!	PapaTom	PowerPoint	7	02-25-2013 06:12 PM
Command Button to Print Labels	Claytocb	Excel Programming	1	02-01-2013 12:20 AM
Command button - save in temp folder and send email with attachment	bigbird69	Word VBA	13	11-18-2012 10:06 PM
Word doc bug when closing from userform command button click macro	Joe Patrick	Word	1	07-05-2011 08:53 PM
command clear forms	dmcohio	Word	0	04-08-2010 11:11 AM