Hi,
Can you please tell me the procedure, how to install the excel in the server.
I am trying to generate the excel report through an scheduled agent , but when in the agent when it reaches to below line it is giving error in the cosole as “Opeartion is disallowed in this session”.
Set xlApp = CreateObject (“Excel.Application”)
when reaching this line giving message in the console as “Variant doesnot contain an Object”.
Set xlWorksheet = xlWorkbook.Worksheets(1)
Please help me regarding this.
Subject: How to install excel in server
It probably won’t work. Microsoft recommend not installing office on a server. Because many of the office products hold information in a USER registry key, Domino running as a service can’t access the relevant information. This is especially problematic with Word.
One way round is to run the Domino service as a user account. You can then see mapped drives, word templates and that sort of this, but the domino console won’t then show , even if it is running
Subject: RE: How to install excel in server
The issue may be with the version of Office. 2007 may require a logged-in user. I have exactly this configuration running with Excel 2003. The Domino server is running as a local machine, not a user, and I have scheduled agents that invoke Excel, format and save xls files.
You do also need to make sure that you set the Agent properties to Allow Restricted Operations. Without that setting, it cannot access the local file system.