How to make Excel file read only?

[EwS]

I am creating an Excel file programmatically. I would like to make it read only. How can I do this?
Thank you.

 

[EwS]

And I also need a way of making the read-only file writable programmatically.

 

[EwS]

File.SetAttributes(fileName, FileAttributes.ReadOnly)
File.SetAttributes(fileName, FileAttributes.Normal)

 

[SiriusBlackOp]

There should also be a set of methods availible on the workbook object to Protect the document from making changes similar to this.

Protect(Read Only):
Application.ActiveWorkbook.Protect("password", True, True)

Unprotect(Modify/Write):
Application.ActiveWorkbook.Unprotect("password")

Senior Software Developer

http://www.scoutsft.com

 

[djj55]

At a previous position (i.e. they have the code) I created Excel files and locked them but do not remember the code. The Password idea is useful but was not what I used.

Check Microsoft's KB for how to examples.

Good Luck
djj

 

[SiriusBlackOp]

The password is optional and protecting them = locking them.

Senior Software Developer

http://www.scoutsft.com