Hi Guys I’m trying to run an scheduled agent with an excel on it. If I tried to manually run the agent, it is successful, but when the agent is run on a schedule basis an error will be triggered on the excel part. The error is “Variant does not contain an object”. The error is probably due to no excel program is installed in the Domino server. My question is , is there a workaround on generating an excel file through scheduled agent, even if there’s no excel file installed on the Domino Server. Appreciate your halp. Thanks
Subject: excel
There’s not a simple way round it, no. If you don’t have excel on the server you can’t create an excel file directly.
What you can do of course is create a csv file or similar which can then be opened in excel later. Of course depending on formatting this may not be as convenient.
If you give some details on what you’re trying to do with the file (is it a report you’re emailing to people or something else?) then there may be solutions