insert date and time

[rafhtaher]

i need a code to insert date and time as soon as excel file opened
can you that
thank you

 

[mumps]

Where do you want to insert the date and time?

 

[JoeMo]

Where do you want the date and time inserted?

 

[rafhtaher]

Where do you want the date and time inserted?

like cell A1

 

[mumps]

Do the following: Hold down the ALT key and press the F11 key. This will open the Visual Basic Editor. In the left hand pane, double click 'ThisWorkbook'. Copy and paste this macro into the empty code window on the right. Close the code window. Save your workbook as a macro-enabled file and then close it. When you re-open the workbook, the date and time will be in A1 in Sheet1.

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