Macro to create log file with user name

[Rajender]

Hi All,

Can anybody suggest if we can create a macro to create a log file with user name detail along with date and time as soon as any user save the document ?

Thanks in advance.

Regards,
Rajender

 

[BBD]

Hi Rajender,

Yes this can be done.

Below is a file which does exactly that for you.

Cheers,
BD

 

[Rajender]

Thanks a lot BBD. its working file

Regards,
Rajender

 

[BBD]

Glad to help

 

[Abhijeet]

Can u give for same identify User Name using Shared workbook Please give me AddIn

 

[BBD]

Hi,

You can use the same codes, but link the updation of log into an external file. So, everytime any user saves the shared workbook, it writes an entry to the external log.

 

[Abhijeet]

No I want add in or Separate macro file I don't want in same file using macro so please give me according macro