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 |
Macro in Excel 2003
Hello Vicki, When you save the file for the others, save it using Save As. This will give you the option of saving it in different formats. Click on the arrow in the "Save as Type" combo box to see a list of available file formats. Excel 10.0 should be in the list. Select it and click Save. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=488248 |
All times are GMT +1. The time now is 10:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com