The information in this article applies to:
SUMMARYIn Microsoft Excel for the Macintosh version 3.0, the Auto Save add-in macro included in the Microsoft Excel Library periodically saves all open files. You can activate the macro by opening Auto Save from the Macro Library folder. Auto Save functions correctly unless it attempts to save when there are no files open. In that case, the macro halts. You can avoid this problem by modifying the add-in macro with the following steps:
MORE INFORMATIONThe error occurs because the Auto Save add-in macro does not check to see if any files are open before attempting to save all files. Adding the line above forces Excel to attempt to get a list of currently open files with the DOCUMENTS(1) function and cancels the macro if there are no files open. REFERENCES
"Microsoft Excel User's Guide 2," version 4.0, pages 195-202 Additional query words: 3.0 3.00 4.0 4.00
Keywords : |
Last Reviewed: October 21, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |