Cannot access read-only document 'excel_filename.xls'

Question

Iam working on c# console. what iam trying to do is to get excel template and insert all records in in excell and create a copy to save the excel to network shared folder using a impersonated specific user..but the error was Cannot access read-only document 'excel_filename.xls'. please see my code snippet see error SaveAsCopy

mary jean ligas · Answer

scenario: i use my pc with accouunt: mjtligas then in program i swicth account impersonated: s-iosgxrsu the shared folder in network drive in other pc has a full persmission to s-iosgxrsu in saving the file cannot access read-only document..that is the error

mary jean ligas · Answer

Hi Sir Raj the error says The name ReadOnly does not exists in the current context

Rajeev Punhani · Answer

Hi Mary Please try xlWorkBook = xlApp.Workbooks.Open(strReportTemplate oMissing false oMissing oMissing oMissing oMissing oMissing oMissing oMissing oMissing oMissing oMissing oMissing oMissing);

mary jean ligas · Answer

Thanks

Amatya Gupta · Answer

I dont know dear.. Have to wait for someone to reply... Its better to talk to your Server Admin.

mary jean ligas · Answer

what is the proper setting you will recommend?

Amatya Gupta · Answer

Oh... so make the setting proper dear

Amatya Gupta · Answer

Your suspection might be right. Have you asked to your system admin to solve the issue?

mary jean ligas · Answer

hi sir Amtya I applied full permission in a file but I suspect that in launching excel file the user impersonated didn't applied so that in saving over the network the file is read only..

Amatya Gupta · Answer

Dear If its working in ur local system then in share folder you have to give the permission. Better ask to your System Admin. I think some restriction they have applied

mary jean ligas · Answer

have you seen my code?

mary jean ligas · Answer

sir Raj we have full permission set-up to the user account..i don't know how to why it is not working. The error is occur in SaveAsCopy part..

Rajeev Punhani · Answer

Hi Mary This issue can occur if you are saving to a network drive and you do not have sufficient privileges to save to that drive. Thus you might not be able to access the file. File might be read-only and user is not allowed to access it. Read-only nature of a file implies that it is not allowed to access or modify a file. Please check folder permission.

mary jean ligas · Answer

it is working if the it is saved loacally but the target is to save it to shared network drive..please help

Rajeev Punhani · Answer

Hi Mary Try to save the Excel file locally and then check if you are able to access it.