[RESOLVED] How to print time elapsed in EXCEL

[puyo85]

hi do anyone here noe how to print time elapsed in EXCEL ? not in window not in other form..i just want it print in excel spreadsheet..thx alot..

[okosv]

Add reference to MS Excel library in Project>References
than use this code

Dim objExcelApp As Excel.Application,objExcelWb as Excel.Workbook
Set objExcelApp=New Excel.Application
'objExcelApp.Visible=True
Set objExcelWb=objExcelApp.Workbooks.Add
objExcelWb.Sheets(1).Cells(1,1).Value=Now
objExcelWb.SaveAs "C:\timewb.xls"
objExcelWb.Close
objExcelApp.Quit
Set objExcelWb=Nothing
Set objExcelApp=Nothing