Article ID: 160085
Article Last Modified on 10/10/2006
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q160085
SYMPTOMS
In Microsoft Excel 97, when you run a Visual Basic for Applications macro, and then attempt to access a demand-loaded add-in, you receive an error message, and then Microsoft Excel quits.
In Microsoft Windows 95, you receive the following error message:
In Microsoft Windows NT 3.51 or later, you receive the following error:
NOTE: The exact address in the message may vary.
CAUSE
This problem occurs when the following conditions are true:
- You run a Visual Basic for Applications macro during the Microsoft Excel session. -and-
- You access a demand-loaded add-in while no workbooks are open in Microsoft Excel.
WORKAROUND
To prevent this problem from occurring, open at least one workbook or start a new workbook before you access the demand-loaded add-in.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000.
MORE INFORMATION
"Demand-loaded" means that an add-in is set up for use in Microsoft Excel; functionality in the add-in is available dialog boxes and menus, but the add-in file is not actually loaded into random access memory (RAM) until the functionality is requested. Demand loading an add-in requires less time than fully loading the add-in into RAM.
You may experience the problem that is described in this article when you access one of the demand-loaded add-ins in the following list:
AutoSave
Conditional Sum
File Conversion Wizard
Internet Assistant Wizard
Lookup Wizard
Report Manager
Solver
Template Wizard with Data Tracking
Web Form Wizard
Additional query words: XL97 8.0 8.00 addin __demandload demandload save as html fast load
Keywords: kbbug kberrmsg kbprogramming KB160085