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


 Product:
 Export Utility for Lotus Notes / Domino > Scheduled Exports > Version All

 Platform(s):
 Windows 64 Bit

 Edition(s):
 All

 Doc Number:
 1000058
Published 16-Apr-2013
Last Updated: 29-Oct-2019

 Problem

When running a scheduled export 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.

SaveAs method of Workbook class failed
To fix this problem create a folder called 'Desktop' 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 ensure the folder called 'Desktop' exists under the 'C:\Windows\System32\config\systemprofile' folder.

Microsoft Excel cannot open or save 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.

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 export and see if Excel now successfully loads.

You can also enable this option via the command line on the server:
  • Open a command prompt on the server
  • Change to the following directory: %systemdrive%\Inetpub\AdminScripts
  • Type in the following command: cscript.exe adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 "true"
  • Press the enter key

IBM Technote: Error: 'Cannot create automation 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


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