Sheets("Usage").Copy

Would create a single sheet workbook with the worksheet "Usage" in both
xl97 and xl2003. That workbook would be the activeworkbook in both. So I
don't see any obvious cause for the observed difference.

--
Regards,
Tom Ogilvy



"Pete" wrote in message
ups.com...
Hi Tom,

When I Test this out at home on Excel 2003, I get at you describe, but
when sent from a PC with Office 97 on it at Work, I get an exact
replica of the workbook it is sending the "Usage" sheet from, I can't
understand why.

Pete