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