Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Track when a file has been opened
I have a Shared file so that I can see who made what changes when, but I
would also like to track when the file has been opened, but no changes made. Is this possible? Thanks so much! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Track when a file has been opened
1. create a log sheet called "open log"
2. put the following macro in the ThisWorkbook code area. (the Save is needed to trap opens w/o saves) Private Sub Workbook_Open() Sheets("open log").Activate Dim n As Long n = Cells(Rows.Count, 1).End(xlUp).Row + 1 Cells(n, 1).Value = Now ActiveWorkbook.Save End Sub -- Gary''s Student - gsnu200739 "Judy" wrote: I have a Shared file so that I can see who made what changes when, but I would also like to track when the file has been opened, but no changes made. Is this possible? Thanks so much! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Track when a file has been opened
I'm sorry, but it doesn't do anything. Perhaps I misunderstood your
instructions. I created a worksheet and named it Open Log, created the macro in ThisWorkbook code area and named it Workbook_Open, and copied and pasted your macro text in it. And nothing happens. I've open and closed the file several times and even made changes, but nothing appears on the Open Log worksheet. I'm obviously missing something, but don't know what it is. "Gary''s Student" wrote: 1. create a log sheet called "open log" 2. put the following macro in the ThisWorkbook code area. (the Save is needed to trap opens w/o saves) Private Sub Workbook_Open() Sheets("open log").Activate Dim n As Long n = Cells(Rows.Count, 1).End(xlUp).Row + 1 Cells(n, 1).Value = Now ActiveWorkbook.Save End Sub -- Gary''s Student - gsnu200739 "Judy" wrote: I have a Shared file so that I can see who made what changes when, but I would also like to track when the file has been opened, but no changes made. Is this possible? Thanks so much! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When was file last opened? | Excel Worksheet Functions | |||
cannot open the excel file, the file is already opened | Excel Discussion (Misc queries) | |||
Why does my .csv file not appear when opened in Excel? | Excel Discussion (Misc queries) | |||
file opened twice on network | Excel Discussion (Misc queries) | |||
Copying the Editing in one file to Another opened XLS file | Excel Worksheet Functions |