writing to disk: File access denied

Question

I try to write my data to an Excel file. I'm using workbook method SaveAs. This is the code:

string FN = "C:\\Users\\Documents\\dane1.xlsx";
WB.SaveAs(FN, Excel.XlFileFormat.xlWorkbookNormal,
            Missing.Value, Missing.Value, Missing.Value, Missing.Value,
            Excel.XlSaveAsAccessMode.xlShared,
            Missing.Value, Missing.Value, Missing.Value,
            Missing.Value, Missing.Value);

Everything is OK while the first parameter is hardcoded. When I try use a reference to object where I'm keeping path and file name (I've got it from SaveFileDialog) my application return me an exception:

File access denied".

What's wrong? Does anybody know how this can be avoided?

Looks like the file is open already (your app has it open for modification). — Steven Evers
– Steven Evers, Commented Sep 12, 2010 at 23:37

Delan Azabani · Accepted Answer · 2010-09-12 23:27:59Z

2

IF you're running Vista / Windows 7 you may need to run your application as Administrator to save to c:\Users\Documents (which generally doesn't exist)

Did you mean c:\Users\'username'\Documents?

in C# you could use Environment.GetEnvironmentVariable("userprofile") to get the users folder (ie c:\Users\Postman) - which is like type %userprofile% into run.

edited Sep 12, 2010 at 23:27

Delan Azabani

81.8k30 gold badges174 silver badges214 bronze badges

answered Sep 12, 2010 at 23:10

PostMan

6,9871 gold badge46 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

writing to disk: File access denied

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related