Harlan and Dave,

Thanks for your answers.

Dave, the sequence is that Notes will open the .wk4 file, so I wanted
to have the macro run automatically in that case.

Harlan, I agree - the Germans should see the date as 24.04.2007, which
is fine, but the Germans aren't reading the file when it opens in 123
- Notes is, and Notes is throwing up on the date not having slashes in
it. What I really want to do is write out 04/24/2007 in all cases,
and I can do that fine - have written VBA code to do that - but when
you open the file in 123, it loses all of the formatting. That's my
problem. I tried putting a quote in front of the cell to make it a
text field, and that kept the formatting, but Notes didn't like that
either. I agree that 123 classic may not be the best idea, but I'm
running out of thoughts on this one! I just wish Microsoft allowed
you to write out .123 files - that would make my life a lot easier!

Thanks,
Brandon