Oli,

No, no, and no. That's the part that has me totally stumped. All the
breakpoints are cleared. The IDE window does not pop-up whether its already
open or not. No lines are highlighted if its already open. No error message
appears. The code just jumps to the Timekeepers.csv and stops(?) executing.

Per your suggestion I deleted the original module and pasted the code into a
new one, but that did not help. I've tried adding Wait times into the code,
I've tried three different ways of selecting the desired cell and inserting
the formula, but it always stops at the point that the new document opens.

Could it be because its a CSV file instead of an Excel file? I don't
know...

Damian Carrillo

"Oliver Ferns via OfficeKB.com" wrote:

Whoops!

What I meant to write was, is there an error? Or does the IDE window pop up
higlighting the line of code in yellow? If the latter, try Ctrl+Shift+F9 to
clear all breakpoints; failing that copy all the code to a new module and
try to run it again (removing the old module)

If there is an error post the number and message recieved...

Hth

Oli

--
Message posted via http://www.officekb.com