View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default Display Current Date & Time in a cell: Everytime I open the wo

Thanks gary, The issue I am having now is: I have a macro that saves the file
and names it with data in Cell A1 which contains the current date and time.
The macro is now giving me an error as I guess there is a ":" in Cell A1. I
am guessing this.

Thanks in advance

"Gary''s Student" wrote:

The following Event macro will put the current date/time in cell A1 of Sheet1:

Private Sub Workbook_Open()
Sheets("Sheet1").Range("A1").Value = Now
End Sub

Because it is workbook code, it is very easy to install and use:

1. right-click the tiny Excel icon just to the left of File on the Menu Bar
2. select View Code - this brings up a VBE window
3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.

To remove the macro:

1. bring up the VBE windows as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

To learn more about Event Macros (workbook code), see:

http://www.mvps.org/dmcritchie/excel/event.htm

--
Gary''s Student - gsnu200902


"sam" wrote:

Hi All,

Is there a way I can display Current Date & Time in a cell which updates
everytime I open the workbook?

Thanks in Advance