Track users who open excel file (new)

Hi Everyone,

I am new to this forum and looking for a code.

I am looking for a log to track who opens a particular excel workbook. But I need this log on a seperate excel file. I know there was an old threda shich eas already answered but it didn't give a solution to have a seperate track log. As my question violate the rules of this formu, I'm posting as a new thread.

Please see the link to the old thread - http://www.excelforum.com/excel-prog...xcel-file.html

Would apprecaiated if any help could be provide.
Thanks

Look at the code from maacmaac. I would suggest creating a CSV of your log. Taking those and the example from MS for the FreeFile function, you should end up with something that looks like this:

Please Login or Register  to view this content.

Hi Mainemojo,

The workbook currently saved as .xlsx. What would be the difference if the workbook is saved as CSV?
I've just tried with your code as it is but the just changed the file format to .XLXS and didn't get any results.
Also, how do I see the name of the user whos has opened the workbook. If I open the log, will it give the name? I've opened the VBA ans clicked 'RUN' but it says "permission denied".

Any help?

When I substitute drive/path/file info and use the following, it works just fine.

Please Login or Register  to view this content.

Based on your error, I'm assuming that you are using a path that you do not have full access to. That would also explain why the CSV is empty. When the user opens the Excel file that has the above code in it, they have to have full access to the file and path.

You could have it send to an Excel format, but it would require additional coding to write to a file without opening it (you would use ADODB), find the end of the used range, and then put data into specific cells.

It's very easy for Excel to open, edit, and save a CSV.

Hi mainemojo,

The excel workbook has multiple sheets. It doesn't allow me to save this excel as '.CSV'.