track who enters into the workbook and what time and when they leave the workbook

**khalid79m** · 12-16-2006, 04:06 PM

Need help with a code that on workbook open it records the users details and time of entry and the time they close the workbook. I have over 100 Excel files mainly accessed by upto ten different people at different times. I just want to keep a track on what time it takes to update each file.

Also on close of work book I would like a macro to seach a specific coloum ie "E" and see how many no blanks there are.

**VBA Noob** · 12-16-2006, 04:23 PM

Hi,

Try this log for help on the log. This will work of the user enables macro's. Adapt the code for the closed workbook part

http://www.j-walk.com/ss/excel/tips/tip95.htm

and this site should help you with the Closed workbook issue. Sumproduct works on closed workbooks.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

If you want to extract info from a closed workbook then try Ron's site

http://www.rondebruin.nl/ado.htm

VBA Noob

track who enters into the workbook and what time and when they leave the workbook

LinkBack

Thread Tools

Rate This Thread

Display

track who enters into the workbook and what time and when they leave the workbook

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions