OFF95: "Illegal Operation" Error Running Macro in Binder

Last reviewed: March 10, 1997
Article ID: Q133331
7.00 WINDOWS kbprg kbole

The information in this article applies to:

  • Microsoft Office for Windows 95, version 7.0
  • Microsoft Excel for Windows 95, version 7.0

SUMMARY

In Office Binder, when you run a macro in a Microsoft Excel worksheet section, you may receive an Illegal Operation error message. If you click Details, information similar to the following appears:

   EXCEL caused an invalid page fault in module VBA32.DLL at
   0137:00b30d7d.

When you click Close, you may also receive an illegal operation error message in Binder.

CAUSE

This problem occurs if the macro that you run returns the following error message in Microsoft Excel:

   Sub or Function not defined

For example, if you create the following macro

   Sub Test()
      msgbxo "test"
   End Sub

(note the misspelled "MsgBox" command), when you run the macro in Microsoft Excel, you receive the "Sub or Function not defined" error message as expected. However, if you run this same macro from a Microsoft Excel worksheet section in a Binder, you receive the Illegal Operation error message.

WORKAROUND

To avoid this problem when you run a macro in a Microsoft Excel worksheet section in a Binder, run the macro first from within Microsoft Excel, before you run the macro in Office Binder. If the macro is already in a section in a Binder, click View Outside on the Section menu to view the macro in Microsoft Excel. You can then run the macro, and modify your code to correct any run-time errors or misspelled commands.

Note that the only way to view a module sheet in a Microsoft Excel worksheet section in a Binder is to view the Microsoft Excel worksheet section outside the Binder by clicking the View Outside command on the Section menu.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here as it becomes available.

REFERENCES

For more information about adding a document to a Binder, click the Index tab in Binder Help, type the following text

   Binder, adding

double-click the selected text and then double-click "Add a new document to a binder" to go to the "Add A New Document To A Binder" topic.


KBCategory: kbprg kbole
KBSubcategory: xlwin offwin

Additional reference words: 7.00 crash gpf

Keywords : offwin xlwin kbole kbprg
Version : 7.00
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 10, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.