LockXLS On-line Help Library

no items
no items
no items
no items

Access LockXLS Runtime Object from external application.

Excel File Compiler Screenshot

If you are using COM to open locked workbook in Excel from your application, you can access LockXLS Runtime object in the following way:

' launch Excel application
Dim oExcel As Object
Set oExcel = CreateObject( "Excel.Application" )
' declare variable for LockXLS Runtime object
Dim oLockXLS As Object
' get Runtime Object from Excel application
Set oLockXLS = oExcel.COMAddins( "LockXLSRuntime.Connect" ).Object;
' use LockXLS Runtime object
oLockXLS. ...
' open locked workbook
oExcel.Workbooks.Open( "path to locked workbook" )
' release LockXLS Runtime object
Set oLockXLS = Nothing

See Also:
LockXLS Runtime Object members