#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 |
#2
|
||||
|
||||
Hi gg80,
That code should work exactly the same in Excel 2007.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
Hello,
Quote:
If it doesn't seem to be doing anything, make sure that: (1) the code is in the ThisWorkbook class module of the workbook (2) macros are enabled (3) events are enabled (type Application.EnableEvents=True into the immediate window) If it gives you a runtime error then please give us the details of the error. It could be the case that (1) a sheet called Sheet1 doesn't exist (2) Sheet1 is protected. Hope that helps... |
#4
|
|||
|
|||
Head slap! I entered code in excel 2003, it worked, and I expected it to work in excel 2007. I didn't know about "enabling macros". Thanks very much-problem solved.
|
|
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 |