Get Everything Done

<< "runtime error (9): subscript out of range" >>

Moises: I am not sure if you are still getting this error... I ran the de-bugger when I got the same error and it appeared to come on if you changed the name of the file to something other than the original "DWM". The error disappeared when I changed it back to the original.

I suppose you could change the code to reflect your new file name, but I'm not a code expert, so did the above instead. Hope that helps in some way.

Hi!

JD is right. The file name is important, because if you have more than one Excel file open, it needs to know where to go back when you press "Complete".

Frankly, I programmed this feature just for fun (since I'm not so much into statistics), but I find myself using it more and more. I'm amazed to find out how much time I invest in things that seemed to go on only for a couple of minutes.

Hope you enjoy it,
Walter

JD and Walter,

That was the problem! Thanks for the solution.

moises

Everything works well, except sometimes, when I switch applications, I get runtime error 1004: "Method 'OnTime' of object '_Applicaton' failed"

The script stops at "Stop the time, and hide the window"

I am still using it despite the bugs.

Hi,

This version should fix the problem you mention:

http://rs924.rapidshare.com/files/364574276/DWM.xls

Please let me know if it does (or not).

Regards,
Walter

Walter,

The runtime error seems to be fixed. I still get the watch stopping, when I switch to one of my applications. But that's a minor issue.

Another minor issue. Can you change the format on the Stopwatch to the same hh:mm:ss format that you use in the "invested" column F on Closed Tasks?

And thanks again for everything you've done on this.

Hi Moises,

I kind of suspected that some kind of problem could arise. :-(
Excel doesn't have a proper timer.

Can you point me to the kind of situation when this happens?
Is it a specific application that causes it?

In any case, if things aren't stable, I have a simpler, less fancy option:
I can simply save the starting time, and when you press CTRL-Shift-C or R, calculate the difference. That wouldn't show the progress, though. You could only know how much you worked when you finish.

Walter,

The stopwatch seems to fail only when I use a "terminal server" application. I don't mind at all, since it seems to be good with everything else.

But here's another thing I just discovered about the stopwatch.

Let's say that I am in cell A23, with the description "Task1". I turn on the stopwatch for this task and the message box is titled "Task1." While I am doing Task1, I realize that I need to enter another task. So, I go to my first empty cell, which is A35 and enter "Task2". And this cell A35 remains selected.

After I complete Task1 I hit the "complete" button on the "Task1" stopwatch box. What happens next is that Task2, not Task1, is moved from the Open to the Closed tab.

I like your less fancy option. Right now, I put a semicolon (;) next to the active task in column H. (I use column G for extra notes and things.)

This way, if I need to move around the sheet, while I am working, I can always get back to the selected task with a search for the semicolon, or go to column H and do End-up arrow.

When we hit CTRL-shift-W, make the selected cell have yellow fill and put a semicolon (or some other character) in column H. Then, proceed using your "less fancy option."

On the Closed Tasks tab, Column E, I would like to see the time the tasks were closed be the default format. Again, it's just a minor thing.