October 13, 2015, 12:38pm
I have copied this VBA-Code from the User Guide:
Public Function SaveSecureWorkbookToFile(Filename As String)
Set XLSPadlock = Application.COMAddIns(“GXLS.GXLSPLock”).Object
SaveSecureWorkbookToFile = XLSPadlock.SaveWorkbook(Filename)
I have tried to use this function but in the line
"Set XLSPadlock = Application.COMAddIns(“GXLS.GXLSPLock”).Object"
it appears the runtime error:
Index außerhalb des gültigen Bereichs
Please let me know how this error can be resolved.
with best regards
The VBA code from the user guide has been updated in XLS Padlock 2.1. Please update your code and the VBA error 9 will be fixed.
October 26, 2015, 4:02pm
I have installed the latest version and adopted the code accordingly.
The line of code “Set XLSPadlock = Application.COMAddIns (” GXLS.GXLSPLock “). Object” generates said mistakes again and again.
Is that maybe because a DLL is missing on my machine: GXLSPLock.dll?
This DLL has not been installed.
The VBA code snippets in the user guide have been updated too in version 2.1. Please take a look at the user guide and replace your existing code with the new one. It should fix these mistakes.
November 19, 2015, 12:57pm
I have the code from the new User Guide Version adopted.
The fault no. 9 but is still displayed.
What should I do?
Please double-check that the “On Error goto …” line is in the new code.