LockXLS On-line Help Library

Welcome
Getting Started
Using LockXLS
How to ...
General Questions
Questions about LockXLS activation
Advanced Questions
LockXLS Runtime Menu
Samples
About LockXLS
Purchase
Contact
Open protected file without asking password

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

All methods of the LockXLS Runtime object