Microsoft Office Excel cannot access the file

Question

I have create Office Excel application in my machine(XP). and i have placed the application in windows server 2008 giving the following error.

Microsoft Office Excel cannot access the file '\server\Input.xls'. There are several possible reasons:

• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.

both client and server systems installed office 2007 and added reference microsoftexcellibrary 12.0

created assembly for the application and calling the code from the form.

Answer 1

I would make sure no Excel processes are running on the machine before you run this application, that should cover the last point.

The first point looks the most likely issue, the path looks like a partial path or an incorrect UNC path. Try putting the full path to the spreadsheet 'C:\server\input.xls' and see if that works.

To stop the middle point, in the workbook.open command you can specify to open as read-only, this will make sure the application can red the file even if it is locked open by another user.

Hope this helps