I have a form users fill out to get what they need from our production dpeartment. The problem is, most don't save their orders after printing them, then they re-use an old order and type in new data while not changin everything on the form.
I already have a command button to save to the main server using this code:
[vba]Private Sub CommandButton1_Click()
ActiveSheet.SaveAs Filename:= _
"S:\Traffic\Prod Orders\" & Sheets("Sheet1").Range("B8") & " - " & Format(Now, "mm-dd-yy hh.mm AM/PM") & ".xls"
End Sub[/vba]
What can I add to print, then clear the contents (including buttons & checkboxes), and finally bring a clear worksheet?