Hi Duke,

Thanks for the reply. The code I posted will pull a range of data from
a 2003 workbook into a 2007 workbook and vice versa when I open either
of them. In the 2003 workbook I am using the Jet engine and in the
2007 workbook I am using the ACE engine. This works fine if, but what
I need is to push the data from one version to the other when I close
each workbook to keep them in sync and I haven't sussed that yet. When
I do, I'll post it here and hopefully it will be of use to you.
Perhaps you would let me know if you crack it first.

Andy