Hi
First of all you cannot use arithmetical operators in a filename. So a format of dd/mm/yyyy cannot be used. In the example I have used dd-mm-yyyy.
See template with code embedded herewith.
You need to change one line of code to suit your needs as follows:
ChDir "D:\Test Folder"
Change it to the location you want to save your files to.
As for putting a mask in the DoB cell you can do this if you set up an online form.
Hope this helps.
Good luck.
Tony
|