Get Time Application Was Opened

Re: Open Time

Do you mean when Excel opened, or a workbook/worksheet...

If you mean Excel, I dont think you can get that information too easily...

If you mean a workbook / worksheet, this thread might help:

http://www.ozgrid.com/forum/showthread.php?t=44175

Ger

Re: Open Time

The best bet would be to access the "last accessed" date from the binary ("Excel.exe")... havent done this myself before, but Chip Pearson describes how to do it.

http://www.cpearson.com/excel/FileTimes.htm

This articel describes the concept of the "Last Accessed Date".
http://www.febooti.com/product…e-last-accessed-date.html

Note - from the article above -

Quote

Any viewing, copying or moving of the documents, images and other files automatically alters last accessed date stamp of the file

Now - it is very unlikely that excel binary (excel.exe) would be copied/moved, so the it is most likely going to represent the date it was last accessed.

HTH
Ger

Re: Open Time

Maybe I am oversimplifying things but this is how I do it. The following macro will be placed in the Personal.xls which will load everytime Excel opens.

Private Sub Workbook_Open()
Activesheet.Range("A1").Value = Now
End Sub

Re: Open Time

Quote from flee01

I need to know when excel opened. Is there a way to tell this?

Why do you want this?