- System Time and Date
'Below code will give you system date and time
Workbooks("Projectresourcedetailsextract.xlsm").Sheets("Sheet1").Range("K1").Formula = "=Now()"
'To format the date
To expound on Numenor's answer you can do something like, Format(Now(),"HH:mm:ss") using these custom date/time formating options
'Below code will give you system date and time
Workbooks("Projectresourcedetailsextract.xlsm").Sheets("Sheet1").Range("K1").Formula = "=Now()"
'To format the date
To expound on Numenor's answer you can do something like, Format(Now(),"HH:mm:ss") using these custom date/time formating options
No comments:
Post a Comment