HII am having local schedule agent , it open the excel sheet in the same system and create document in same database. the system has admin rights. When i run the agent manually it create doc in the database, but if i schedule the agent is not creating document , it seems it couldnt open the excel file . i am not getting any error. The system has admin rights too, any idea for this problem
Subject: Local shedule agent
It sounds like your scheduled agent is running on the server and there you cannot access Excel.
Subject: RE: Local shedule agent
no the db is on my local only , i am forced to keep this db on local only.
Subject: RE: Local shedule agent
Have you enabled local scheduled agents for your location? Is Notes running?
Subject: RE: Local shedule agent
yes I have enabled and notes is running even when i check the log by right clicking the agent the log says agent run successfully. but its not creating the documents in the local db. default i gave manager access to this db.
Subject: RE: Local shedule agent
And does your agent do any logging? If not, then add code to it to make it log (look at the NotesLog class).
Subject: RE: Local shedule agent
its not opening the excel file i gave the msg in my code if excel file open , its not opening even i wrote log and noticed that the file not opened. even i shared the folder where i kept the excel sheet.
Subject: RE: Local shedule agent
Yes, but is it getting to the line BEFORE you try to open the Excel file? If you want to figure out what’s going on with a scheduled agent running AS a scheduled agent, then you need to do verbose logging (log EVERYTHING).
Subject: RE: Local shedule agent
Thanks Stan am getting like this error creating product object error in my log.when the agent come to the below line .
Set varXLFile = CreateObject(“Excel.Application”)
pls suggest me whats will be the problem
Subject: Local shedule agent
i am getting like this error creating product object error in my log.when the agent come to the below line .Set varXLFile = CreateObject(“Excel.Application”)
pls suggest me whats will be the problem.