Microsoft Excel error occurs when running scheduled import on Windows 64 bit


 Product:
 Import Utility for Lotus Notes / Domino > Scheduled Imports > Version All

 Platform(s):
 Windows 64 Bit

 Edition(s):
 All

 Doc Number:
 1000076
Published 16-Apr-2013

 Problem

When running a scheduled import on Windows 64-bit platform the various errors may occur. This support note provides a list of common errors and recommended solutions.

 Solution

Various problems you may be experiencing and possible solutions are outlined below.

Desktop folder is missing
A folder called 'Desktop' must exist under the 'C:\Windows\SysWOW64\config\systemprofile\' folder on the Windows 64-bit server. This folder is required for Excel automation and is not always automatically created.

If the Windows server is 32-bit or the version of Microsoft Excel is 32-bit ensure the folder called 'Desktop' exists under the 'C:\Windows\System32\config\systemprofile' folder.

Cannot create automation object
Windows server 2003, and later, provide the capability to run 32-bit applications on 64-bit Windows using the Windows-32-on-Windows-64 (WOW64) compatibility layer. Using WOW64 32-bit applications (such as personal productivity applications needed by software developers and administrators) can run in a 64-bit environment. On some servers this option may be disabled by default.

If Internet Information Services (IIS) is installed then follow these steps on the server to enable this functionality:
  • Click the 'Start' button then select 'Administrative Tools -> Internet Information Services (IIS) Manager'
  • The IIS Manager window should open
  • Expand the server name and click on 'Application Pools'
  • The list of application pools should now be displayed.
  • Scroll down through the list and locate 'DefaultAppPool'
  • Right mouse click DefaultAppPool and select 'Advanced Settings' from the popup menu
  • Look for the option labelled 'Enable 32-Bit Applications'. Set the value for this to 'True'
  • Click the Ok button to save the changes.
  • If you have any other websites / servers in the list you may want to repeat the process for each.
  • Close the IIS Manager box
  • Run the import and see if Excel now successfully loads.

If you continue to experience further problems please read through the rest of this support note for additional information / troubleshooting steps.

Microsoft Excel cannot open any more documents because there is not enough available memory or disk space
Select the Run option from the server Start menu and type in: MMC comexp.msc /32

When the MMC window has opened perform the following steps:
  • Expand the following folders: Component Services --> Computers --> My Computer --> DCOM Config.
  • Scroll down the list of options under the DCOM Config heading and locate 'Microsoft Excel Application'.
  • Right-click on 'Microsoft Excel Application' and select 'Properties' from the popup menu.
  • When the properties box has opened click the Identity tab.
  • Set the User Account option to 'The interactive user'
  • Click the ok button.
  • Close the MMC window.
IBM Technote: Error: 'Cannot create automated object' when executing LotusScript CreateObject function on server
Please read the following technote from IBM regarding this particular error:

Cannot create automated object.pdfCannot create automated object.pdf



  Related Attachments


© 2013 AGE Computer Consultancy. All rights reserved.
Material may not be reproduced or distributed in any form without permission.