Search results

Thank you Jan, Yes, it helped a lot. Cheers, Roberto

Guys, this topic is CLOSED. The problem was not about classes or modules. Actually I did not understand the Manual item 9.3 (and still trying to figure it out). I have corrected the coding to adjust to the XLSPadlock function for saving *.xlsc file but it gives an error “Variable not defined”...

Hi nd09, Did you sole the issue with saving the file into the .xlsc? Have you received a VBA error saying “Variable not defined” and pointing into the “XLSPadlock” below? Set XLSPadlock = Application.COMAddIns("GXLS.GXLSPLock").Object Thanks, Roberto

Hi Skoriq, Didi you solve your issue? because I am having the same and I’d like to know your process worked out. Thanks in advance. Have a great day. Roberto

Hi, JanJ I saw your string of messages with gdg and I’d like to know if you simply inserted the function and made the variable Filename includes the whole name of the file with the extension .xlsc? I greatly appreciate your feedback because I am having VBA error saying the variable XLSPadlock...

Guys, it is confirmed. XLS Padlock does not support class modules, only Modules. For some reason the classes can not be instantiated and all that UML and OOP like programming had to be replaced by another interpretation of OOP. With the replacement to Modules, I could open the app and operate...

But what I did was, I removed all class modules and changed them into Modules. I am testing now to see if the thing keeps the same.

No. Didn’t use the VBA compiler neither any snippet.

Hi, All VBA program works well when I run from the VBA editor in my computer. But after compilation and testing in other computers, with the same configuration as mine (win 7pro 64-bits with MS Office 2013 Plus 32-bits) I receive the following message: "Compile error in hidden module: . I use...