Hi,

I have an excel speadsheet that conatains a macro which performs some
automation tasks. The Macro was originally written with Office XP on
a
Windows XP System. The idea is something like the following:


1. Original template file opened (Read only) by party X who enters
some info into a form
2. When the command button in Excel is clicked a copy of the workbook
is saved and attached to an email which is sent to Party Y
3. Party Y who is using Office 2003 opens the sheet attached to the
email, makes some further changes to the form, then clicks the button
again. This saves a new copy and attaches the new copy to an email
which is passed back to Party X.


The problem is that the orignal workbook has "References" to various
Microsoft Office 10 Object Libraries (Excel and Outlook). When this
copy is opened using Office 2003 these references are updated to
point
to Microsoft Office 11 Object Libraries and the Macro runs fine but
when this is saved and passed back to Party X as in stage 3 mentioned
above the object Libraries (specifically the Outlook Object
Libraries)
don't revert back to Microsoft Office 10 Libraries as hoped.


So in short how can I get a macro saved in Office 2003 to work in
Office XP?


Any help on this would be appreciated.


Paul