Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word VBA

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-11-2019, 06:40 AM
sfitzsimmons sfitzsimmons is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2019
Posts: 1
sfitzsimmons is on a distinguished road
Default Word Form to Save as and clear


I have built a Word form where there are drop downs, free filling and data selection boxes. I restricted editing to allow users to fill in the form but did not password protect.

Is there a way to have a button that will SaveAS with a new file name and then clear the form for the next user??
Reply With Quote
  #2  
Old 01-11-2019, 02:03 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,099
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

If you use a 'clear' Word template (i.e. a file saved in the .dotm format), double-clicking on that will create a new document with the fields cleared (the same applies if the user chooses File|New and selects that template); it will also minimise the risk of your template being saved over with user data. No code required.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reset "Button" to clear Word user-filled form, from all filled details. Rafi Word VBA 15 11-28-2018 11:31 PM
macro command button, save and print and clear fatboy1973 Word VBA 4 07-06-2017 08:23 AM
Don't clear form fields when protecting as a form BruceM Word 5 10-06-2016 08:26 AM
VBA to save word user form value to xml Rose roon Word VBA 25 06-23-2015 04:35 AM
how to save contents in textbox in VB2013 form into a Word document? saltlakebuffalo Word VBA 6 12-10-2014 06:12 PM


All times are GMT -7. The time now is 10:07 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft