Hi,

I am completely new to this VBA Code. Honestly cannot make a sense of anything yet!!

After a lot of internet research I have found a code to track user activity, like who opened the file and closed and what changes were made at what time etc ...(the person who posted that claimed it would do all this stuff!!!)

I copied the text and pasted in the module/code and saved the file as directed on the website. But what next ???

The user mentioned this line " You need to change the Const declaration to point to the location you want to store the file at. The file does not have to exist yet - it will be created if it doesn't already exist, but the path to it must already exist.

'change this to a path accessible to all users of the file
'best to use the full network reference than to use
'a mapped drive letter in case the location is not mapped when the file is used.
Const recordFile = "\\OurSERVER\Folder1\Folder2\useLog.txt"

I am note sure where does this file "Const recordFile" gets created and how to access it, though I know where I would like to map it.

This really feels like, I have got what I wanted to do, But I don't know where to see the results.

Any help will be appreciated.
Lin