Workbook.ChangeFileAccess Method (XlFileAccess, Object, Object)

 

Changes the access permissions for the workbook. This might require an updated version to be loaded from the disk.

Namespace:   Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

void ChangeFileAccess(
	XlFileAccess Mode,
	object WritePassword,
	object Notify
)

Parameters

Mode
Type: Microsoft.Office.Interop.Excel.XlFileAccess

One of the XlFileAccess values. Specifies the new access mode.

WritePassword
Type: System.Object

Specifies the write-reserved password if the file is write reserved and Mode is xlReadWrite. Ignored if there is no password for the file or if Mode is xlReadOnly.

Notify
Type: System.Object

true to notify the user if the file cannot be immediately accessed.

If you have a file open in read-only mode, you do not have exclusive access to the file. If you change a file from read-only to read/write, Microsoft Office Excel must load a new copy of the file to ensure that no changes were made while you had the file open as read-only.

For information on optional parameters, see Optional Parameters in Office Solutions.

Return to top
Show: