Forum Discussion
Counting keystrokes instantly
Howdy, This is a long question, so here's a bit of context: My colleagues often conduct detailed counts using an archaic mechanical counter. I'm trying to digitize it and also speed up the data pr...
https://answers.microsoft.com/en-us/msoffice/forum/all/window-handler-in-excel-vba/ccdee036-1755-4589-a79a-94f7b899b3f6 I've used this discussion and the active code by Chip Pearson, to create a loop with a delay of 0.3 second. It logs every active window in Excel and I have performance data in real time on the Freeze Pane. The "Macro L" which is on LinkedIn, I am updating the code now, and will repost on LinkedIn, soon.
In relation to this post about key logging but counting per minute - I have Logged On Active Windows Minute Total for that day of work, and a Logged On No Active Windows Minute Total. This was useful when I was doing a very automated work stream.
But now I am doing work on one document for a while. So I am looking to add to the in Active Window Minutes. I intend to add code to seperately count key presses and mouse movements per minute. To get a true Logged On Active Time, I really need to know how many minutes there were no Active Window changes & No Key Presses & No Mouse moves.
So I am looking for some code to count key presses and mouse moves and add it into my Macro L loop. For interest the Macro L saves to a C Drive folder at Lock Screen when going on a break.
