Open protected file without asking password
If your workbook is protected with a password and opened from external application (other workbook), you may want to avoid showing password request dialog to customer. This task could be easily resolved, you need to add the following code to procedure, which opens your workbook:
' declare variable for LockXLS Runtime object
Dim oLockXLS As Object' create LockXLS Runtime object
Set oLockXLS = CreateObject("LockXLSRuntime.Connect")oLockXLS.ActivateWorkbook ("<put your password here>")
... ' open workbook
' release LockXLS Runtime object
Set oLockXLS = Nothing
See Also