You are currently offline, waiting for your internet to reconnect

"Compile Error: Procedure too large" error message when you try to run a VBA macro in a 32-bit version of an Office 2010 program

SYMPTOMS
When you try to run a Visual Basic for Applications (VBA) macro in a 32-bit version of a Microsoft Office 2010 program, you receive the following error message:
Compile Error: Procedure too large
CAUSE
This issue may occur because the VBA macro was created by using a 64-bit version of an Office 2010 program.
WORKAROUND
To resolve this issue, create the VBA macro by using a 32-bit version of an Office 2010 program.
MORE INFORMATION
The 64-bit versions of the Office 2010 program enable you to write a VBA macro that can become too large to use on other computers that are running 32-bit versions of Office programs. This includes 32-bit versions of Office 2010 or earlier versions of Office. A VBA macro that was created for a 32-bit version of an Office application can run on the same 64-bit version of an Office 2010 program and most VBA macros written for the 64-bit version of a program will run on the 32-bit version of the program. However, a macro that is too large will fail together with the Visual Basic for Applications error message that is mentioned in the "Symptoms" section.

As a macro developer, you have to be aware that Visual Basic for Applications 7.0 only guarantees compatibility when the macro is moved from a 32-bit version of an Office 2010 program to a 64-bit version of an Office 2010 program. There is no compatibility when you move from a 64-bit version of an Office 2010 program to a 32-bit version of an Office 2010 program. This means that a macro created on a 32-bit version of Office 2010 can run on a 64-bit version of Office 2010, but macros created on a 64-bit version of Office 2010 may run, but are not guaranteed to run, on a 32-bit version of Office 2010. Developers who create Office 2010 macros should develop them on 32-bit versions of Office 2010 to achieve full compatibility on both 32-bit and 64-bit versions of Office 2010.
Properties

Article ID: 983044 - Last Review: 07/07/2010 05:08:00 - Revision: 2.0

Microsoft Office Professional Academic 2010, Microsoft Office Home and Business 2010, Microsoft Office Home and Student 2010, Microsoft Office Professional 2010, Microsoft Office Professional Plus 2010, Microsoft Office Standard 2010

  • kbexpertiseinter kbtshoot kberrmsg kbsurveynew kbprb KB983044
Feedback
crosoft.com/c.gif?DI=4050&did=1&t=">racking = 1; var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write("