Macro in Excel 2003
Hi everyone,
I am using Office 2003, but my colleagues are using Office XP. Someone
created an Excel sheet with Macros.
Everytime after I opened up the Excel sheet and saved the file, my
colleagues will have problem opening the file again.
Finally, we found out that when I open the Excel file, it automatically set
the reference to Microsoft Office 11.0 Object Library. When I save the file,
the reference becomes 11.0, while my colleagues only having the 10.0.
How to solve this problem? Please advice.
Thank you very much!!
KK
|