Friday, 25 October 2013

Excel Macro to get the current system time


Call getSystemTime()

Sub getSystemTime()

'below program will display current system time in excel macro

MsgBox Time

'To  display time stamp, you can use below code excel macro
MsgBox Now

'To extract the time part from the timestamp, you can use below code

MsgBox TimeValue(Now)
'Above code will print only the time part i.e current time
End Sub

What do you think on above excel macro topic? Please provide your input, comments, questions on excel macro. I will try to reply as soon as possible. I value your opinion on Excel Macros.

No comments:

Post a Comment

Popular Posts

Search This Blog