Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2003 + macro help | Excel Discussion (Misc queries) | |||
Macro Help Please excel 2003 | Excel Discussion (Misc queries) | |||
how to run acces 2003 macro in excell 2003 macro | Excel Discussion (Misc queries) | |||
Excel 2003 VBA Macro | Excel Discussion (Misc queries) | |||
Macro Still Won't Run in Excel 2003 | Excel Programming |