Trying to help as a fellow user:
Error 1: the compiler has its own way to deal with VBA arrays. You can find how to use the dynamic arrays in the manual. I got it worked basically, but because of its not-so-fast speed, i had to find a way to get arround it - move my code to vb6 and link it back to the compiler. You may find more information in my posts somewhere in the forum.
Error 2: involves with collections. I got the same problem and XLS padlock has answered mine somewhere in the forum. Haven’t tried yet, not sure if it works. My way arround this -move my code to vb6.
Error 3: Involves with error handling. Appears that the compiler does have this functionality but it is in different syntax which hasn’t been documented in the manual.
XLS PADLOCK - can you please help to clarify this?
Besides all of these, in my own opinion, XLS PADLOCK is doing a great work helping our VBA Excel community.