OFF95: "Illegal Operation" Error Running Macro in Binder

ID: Q133331

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.

Additional query words: crash gpf


Keywords          : offwin xlwin 
Version           : 7.00
Platform          : WINDOWS 
Issue type        :

Last Reviewed: June 8, 1999