|johnr: The Op was talking about 97 vs. 2003, not 2007 vs. 2003.|
Without knowing what line caused the error there's not much we can do to help. The next time you get the error, click the Debug button and note which line is highlighted.
Then, after clicking the blue line at the bottom of this post and reading the instructions found via that link, post the code and tell us which line is causing the error.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.