using "save date" in excel.

leviavnon · #1 06-13-2016, 03:47 AM

Is there any way to plant in Excel, an equivalent of the word field :
{ savedate.....mergeformat } ?
-An automatic date that will change each time I save the file?
I tried a simple copy. Didnt work.

please help.
Levi

jeffreybrown · #2 06-13-2016, 04:39 AM

Hello Levi & Welcome to the Forum,

You would have to use code...

Something like this placed in the ThisWorkbook module

Code:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    Sheets("Sheet1").Range("A1").Value = Now
End Sub

http://www.rondebruin.nl/win/code.htm

leviavnon · #3 06-14-2016, 11:34 PM

Hi Jeffrey

thats above my level.
Many thanks.
Levi

KunleExcel · #4 06-15-2016, 08:02 AM

You can use Today function: =today()

leviavnon · #5 06-16-2016, 07:52 AM

many thanks, I wanted a solution simmilar to "save date" like in "word".
appreciate your time.
Levi.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to use a "Save As" button without causing digital signatures to become "Invalid"?	jferg	Word VBA	0	02-16-2016 03:04 PM
When using "Save and Send" from Excel 2010, the email opens with no ribbons and seems to hang.	bjsusol	Outlook	1	03-31-2015 11:03 PM
Disable "Save" & "Save As" & "Print" ribbon	Villalobos	Word VBA	3	07-14-2014 11:37 PM
How to "deactivate" the Excel's SAVE function	KIM SOLIS	Excel	1	11-05-2011 01:57 AM
"Microsoft Excel Application" missing in the "Component Services" on win08	sword.fish	Excel	0	02-26-2010 02:09 PM