Problem in Excel file save method

HCL Domino Domino Forum
1

Hi All,

I have problem in Excel file save method when agent run in schedule based it create excel file but at the time of save it send error that

“Error Ocurred in Quotation Report : 36 & the error is : Microsoft Office Excel: SaveAs method of Workbook class failed”

I have this below code

Filename = “C:\TAS\Quotation Report” +“.xlsx”

xlObj.DisplayAlerts = False

NewBook.Saveas Filename 

NewBook.close

xlobj.quit

this error send at this line "NewBook.Saveas Filename "

and if i run this agent manualy then no error come and i have ms office 2007 in Server any one help me how to avoid this error.

2

Subject: Problem in Excel file save method

Does the entity running your agent have permission to write to the file system?

3

Subject: RE: Problem in Excel file save method

Yes this have permission

4

Subject: Problem in Excel file save method

Check also that the TAS folder exists on the server’s hard drive.

5

Subject: RE: Problem in Excel file save method

Yes server having TAS folder also

6

Subject: RE: Problem in Excel file save method

  1. What version of Windows is Domino running on?

  2. Is Domino running as a service, or as a regular application? If it is running as a service, what account is the service running under?

-rich

7

Subject: RE: Problem in Excel file save method

Thanks for input Scarlet Pimpernel i have solved this problem in another way as this show same problem again and again so i have done this by freefile method.

8

Subject: Why not share how you did it?

If someone like you comes along in the future, and has the same problem, they could then use your alternative method. It’s always good to give as well as take in forums.

9

Subject: Problem in Excel file save method

For permissions you need to check

The id that signed the agent (or if tun on behalf is checked) has rights to run unrestricted on server doc

The windows id that the server is running under in the services has all rights to tas directory