Troubleshooting

Refer to these troubleshooting tips for error messages that may appear when running your application.

Out of memory dialog error messages in Excel

Reason: An out of memory message may be reported if there is insufficient memory available to complete each process, even if it seems that there is sufficient memory available in the system as a whole. In this case, the dialog sniffer log file may contain one or both of the following example messages:
  • InspectWindowHook is invoked_in_response_to_WM_INITDIALOG. 
Tue Oct 19 12:17:47 2004 Entered_Is_A_Message_Box_function... 
The_opened_window's_class_name_is:_<#32770> The_opened_window's_text_is:_
<Microsoft Visual Basic> Static_text_is:_<Microsoft Visual Basic> 
Destroy_patterns_retrieved. Begin_to_inspect_the_window. 
Class_Name:_<Button> Button_contains_this_text:_<OK> Begin_to_inspect_the_window.
Class_Name:_<Button> Button_contains_this_text:_<Help> Begin_to_inspect_the_window.
Class_Name:_<Static> GetWindowText_returns_the_error:_<Cannot create a file when that file already exists. > 
Begin_to_inspect_the_window. Class_Name:__<Static> Static_text_is:__<Out of memory>
  • Inspect_Window_Hook_is_invoked_in_response_to WM_INITDIALOG. 
Tue Oct 19 12:24:25 2004 Entered_Is A_Message_Box_function... 
The_opened_window's_class_name_is:_<#32770> The_opened_window's_text_is:_
<Microsoft Excel> Static_text_is:_<Microsoft Excel> 
Destroy_patterns_retrieved. Begin_to_inspect_the_window. 
Class_Name:_<Button> Button_contains_this_text:_<OK> Begin_to_inspect_the_window. 
Class_Name:_<Static> Get_Window_Text_returns_the_error:_<Cannot create a file when that file
already exists. > Begin_to_inspect_the_window. Class_Name:__<Static> Static_text_is:__
<Not enough memory to run Microsoft Excel.
Solution:
  1. Increase the memory size per process.
  2. Increase the desktop heap value as follows:
    1. From the Start menu, select Run.
    2. Enter regedit to invoke the registry editor.
    3. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\SubSystems\.
    4. Double-click the Windows parameter to display the value data.
      For example:
      %SystemRoot%\system32\csrss.exe ObjectDirectory=\Windows SharedSection=1024,3072,512 Windows=On SubSystemType= Windows ServerDll=basesrv,1 ServerDll=winsrv:UserServerDllInitialization,3 ServerDll= winsrv:ConServerDllInitialization,2 ProfileControl=Off MaxRequestThreads=16

      The desktop heap memory is defined in the SharedSection=1024,3072,512 section in the exmple.

    5. Increase the desktop heap memory.

      The third number (for example 512, in the example) is a non-interactive desktop heap. Because the non-interactive desktop heap is mapped into the address space of each and every process, this value should not be set to an arbitrarily high value, but should only be increased sufficiently to allow all the wanted applications (such as Excel) to run.

Unable to Run Macro dialog errors in Excel

Reason: Excel security settings are set too high, disallowing the client macros from running without direct user approval.

Solution:
  1. In Excel 2007 and 2010, on the Developer tab, in the Code group, click Macro Security.
  2. Click the Security Level tab, and then click Low.

DialogSniffer service does not log data in %SOAM_HOME%\logs\Sniffer and does not recognize FATAL_PATTERNS and NON_FATAL_PATTERNS

Reason: The SOAM_HOME environment variable is not set to the DialogSnifferService process so the sniffer crashes when it creates a log folder or file. (The sniffer calls the ACE method and without SOAM_HOME, it cannot load the ACE.dll file.) This behavior has been observed on all Windows platforms.

Solution: Reboot your machine.

This workbook has lost its VBA project ... message in Excel 2007 and 2010

Reason: This error happens if Visual Basic for the application was not installed during the installation of Microsoft Office 2007 or 2010.

Solution:
  1. Update your installation of Microsoft Office:
    1. Close Excel if it is open.
    2. In Windows Control Panel, select Add or Remove Programs.
    3. Select Microsoft Office in the list, and the click Change.
    4. Choose Add or Remove Features.
    5. Select Visual Basic for Applications in the Office Shared Features list and set it to Run from My Computer. Click Continue.

    After the installation is complete, you will be able to use the Excel file with its Visual Basic application project when you start Excel.