#1
|
|||
|
|||
Insert date when save file
I want to insert the save date in a cell whenever the file is saved. I got this code from google search:
Option Explicit Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Sheets("Sheet1").Range("A1").Value = Format(Now(), "mm-dd-yy") End Sub It works great on excel 2003, but not in excel 2007 (running under W7). I googled to get the above, but found nada about something specific for 2007. Any help much appreciated |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to update automatically the “file name” as we do for the “Date”? | Jamal NUMAN | Word | 2 | 01-06-2011 02:43 PM |
Word Macro: Save file as text with current file name | jabberwocky12 | Word VBA | 2 | 10-22-2010 12:23 PM |
How to save file on CD? | DennisWG | Word | 0 | 09-07-2010 10:41 AM |
How to insert a .mov file in Word Document | Jai25 | Word | 0 | 02-11-2010 04:40 PM |
Trying to insert hyperlink to excel file into Outlook | KarenE | Outlook | 0 | 05-08-2006 12:56 PM |