Hi Ravi,
You can use the following code to get the time taken to perform the functionality.
I have put the time difference in the Data Table. I hope you know how a value is stored in an external excel sheet.
You can use the following code to get the time taken to perform the functionality.
Quote:StartTime = Timer
---Your Code Here
EndTime = Timer
TimeDiff = EndTime - StartTime
DataTable("TimeTaken",dtLocalSheet) = TimeDiff
I have put the time difference in the Data Table. I hope you know how a value is stored in an external excel sheet.