Add date to file name

Save a Word document with current date in filename with VBA code Save a Word document with current date in filename with VBA code To automatically add the current date into the filename when saving the Word document, please do with the following steps: 1.

BuiltInDocumentProperties "Title". Show End Sub 3. After pasting the code into the module, press F5 key to run this code, and a Save As window is displayed with the current date automatically into the File name text box, see screenshot: 4. And then, you just need to type your own file name as you need, see screenshot: Recommended Word Productivity Tools. Insert multiple images across folders into Word document at once.

Merge and combine multiple Word files across folders into one with your desired order. It works great for me! Eric on September 12, am. Thanks so much for this, tested on win10 pro and it works perfectly. Keith on June 21, pm. Ash on March 27, pm.

Eder Silva on March 6, pm. SCS on March 6, pm. Thank you very much, was very helpful, BUT: — you should mention that the date and time string is depending on the format at the local settings of windows. SCS Reply. Vladimir on January 7, pm. Hello Rahull, this script is fine, work for me, but: now is date Joao on January 3, pm. Jorge on July 4, pm. Collectives on Stack Overflow. Learn more. Append current date and time in filename with batch file Ask Question. Asked 9 years ago.

Active 7 years, 5 months ago. Viewed 35k times. Pan Pan 2 2 gold badges 5 5 silver badges 10 10 bronze badges. Add a comment. In the destination editor, next to the connection manager drop down menu, click New.

Select Delimited as the file format and click OK. This will open the connection manager editor. Click the browse button next to the file name field and browse to a file you want to use as the destination. I created a file called MyData.

Click OK to close the editor, then click on Mappings to map the columns in the destination editor and click OK to close it. Next, right click the flat file connection manager in the connection managers window and select Properties. This will open the properties window to the right side of the screen.

About halfway down the list of properties, you will see Expressions.