Thanks Robert,

I had tried something very similar to the code that you posted but couldn't get it to work either.
I did find an interesting thread on a way to do it he
http://windowssecrets.com/forums/sho...el-Office-2003)
but I didn't try that yet either.
What I did do for my dilemma was negate the need to test for a variable at that particular point in my routine.
Basically, I was checking the FileDateTime on a number of different timesheets to see if they had changed and set a flag (variable) so that I could update them later on. The cure was simply to use the FileDateTime as my trigger, run the code to update what I needed, save the new FileDateTime and be done with it. The array I had, steps me through all of the timesheets and I don't need those variables any more. No great revelations here so nothing to share that hasn't already been done thousands of times before.
Thanks again.