Error on open Excel Sheet on Web Services

sergisoft

Hi,

I need to make an unattended export process that collects some data and put it in an excel sheet.
This process is now working but it takes some time to finish, so I decided to execute this action by a call to a codeunit that is published as WebService. This method give me the option to run tasks that will be executed by "other user".

I have other tasks working like this but now, I'm getting some problems with the export to excel process. ](*,)

The problem comes when my process opens excel sheet to modify. The WS is returning the error (attached). This error is telling me that the file can't be found.

1.- I've checked access to the file. 2.- Client and server are all in the same testing server. 3-. No other process of excel are running.

The part of code is:

[b]CreateExcel()[/b]
CREATE(Appl, FALSE, TRUE);
Appl.Visible(FALSE);
XBook := Appl.Workbooks._Open(FileName);

Thank you,

skulla

When you execute a process using Web services or RTC it will look for that file path on the server, so make sure you UPLOAD those files to the NAV server before executing the function.

sergisoft

In this case, everything started to work when I created one folder:

http://social.msdn.microsoft.com/Forums/en-US/b81a3c4e-62db-488b-af06-44421818ef91/excel-2007-automation-on-top-of-a-windows-server-2008-x64?forum=innovateonoffice