ProtectedViewWindow.Edit Method
Opens the workbook that is open in the specified Protected View window for editing.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function Edit ( _
WriteResPassword As Object, _
UpdateLinks As Object _
) As Workbook
'Usage
Dim instance As ProtectedViewWindow
Dim WriteResPassword As Object
Dim UpdateLinks As Object
Dim returnValue As Workbook
returnValue = instance.Edit(WriteResPassword, _
UpdateLinks)
Workbook Edit(
Object WriteResPassword,
Object UpdateLinks
)
Parameters
WriteResPassword
Type: System.ObjectThe password required to write to a write-reserved workbook.
UpdateLinks
Type: System.ObjectSpecifies the way external references (links) in the file, such as the reference to a range in the Budget.xls workbook in the following formula =SUM([Budget.xls]Annual!C10:C25), are updated.
Return Value
Type: Microsoft.Office.Interop.Excel.Workbook
Returns a Workbook object.
Remarks
If the WriteResPassword parameter is omitted and the workbook requires a password, the user will be prompted for the password.
If the UpdateLinks parameter is omitted, the user is prompted to specify how links will be updated. If Excel is opening a file in the WKS, WK1, or WK3 format and the UpdateLinks argument is 0, no charts are created; otherwise Excel generates charts from the graphs attached to the file.
Avoid using hard-coded passwords in your applications. If a password is required in a procedure, request the password from the user, store it in a variable, and then use the variable in your code.
You can specify one of the values, listed in the following table, in the UpdateLinks parameter to determine whether external references (links) are updated when the workbook is opened.
Value |
Meaning |
|---|---|
0 |
External references (links) will not be updated when the workbook is opened. |
3 |
External references (links) will be updated when the workbook is opened. |