ExcelBanter - how do i determine when a file was last opened

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i determine when a file was last opened (https://www.excelbanter.com/excel-discussion-misc-queries/100737-how-do-i-determine-when-file-last-opened.html)

manreis

how do i determine when a file was last opened

Could any one please advise me on how do i determine when a file was last
opened

VBA Noob

how do i determine when a file was last opened

Hi,

You can go to File Properties Stats or you could use some VBA
code.

See attached link for more info

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

VBA Noob

--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=563984

All times are GMT +1. The time now is 08:53 PM.