I've created a master form that people will open, fill in, then save with a
different name. I want the new filename to always be the same text followed
by the date and time the form was saved. Can a macro be created to do this
without needing any user input?
For instance, user triggers the macro and that saves the form as "filename
November 4 2007 090023.doc" where filename is always the same, "November 4
2007" is the current date and "090023" represents the HHMMSS when the file
was saved. The user then clears the form, inputs new data, triggers the
macro and that saves it as "filename November 4 2007 090534".
The form will be used on laptops in vehicles and I'm trying to minimize the
amount of typing the driver has to do, as well as standardize the naming
convention.
--
"He has all the virtues I dislike and none of the vices I admire."
Sir Winston Churchill