XLS Padlock - Urgently - Help Please


#42

Sure, but we have got some other problems we must first solve. It’s normal development unfortunately it can take more time than initially expected.


#43

Perhaps more simple tasks can be solved while working on more complex tasks. I usually do this during application development.


#44

We meant problems in the current build of XLS Padlock.


#45

Problem fixed in XLS Padlock 2018. Please upgrade.


#46

Ok.
I will test it


#47

I just installed version 2018.1 and get an error in all the functions called. I’ve recompiled a hundred times already and do not understand what the problem might be. In the previous version of 2018 everything worked without problems


#48

When you compile your VBA code inside the VBA compiler, do you get an error? Try to change param1 defined as string to variant for instance.


#49

When compiling - no errors!
What you are offering is not necessary!
I will have to redo all points of calling procedures and functions.
I had to remove version 8.1 and I work with 8.0 until you find out the reasons.
I’m constantly programming and can not jump from version to version.


#50

Anyway, that’s probably the reason of your problem.
In the compiled VBA code (in VBA compiler), don’t use types for params.
For instance:
Function test(param1)
and not
Function test(param1 As String)


#51

I don’t use types for params


#52

Why did this problem only occur in 2018.1?
I have more than 7000 lines of code and it is not acceptable in every version to make such global changes


#53

Then try
Function GetOrdersHistory(Param1 As String) As String
The compiler got updated in 2018.1. Without your code, it’s difficult to tell you where the error lies.


#54

I think that’s because of the new ability to accept arrays as params. I’ll ask.


#55

I TRYED and nothing has changed. Errors…


#56

The error appears in normal Excel or in the compiled EXE?


#57

in normal Excel


#58

And not in compiled EXE?


#59

We found the solution for your problem. It will be fixed in a new update tomorrow.


#60

Okay, I will continue to use the previous version.
Please inform me when the update will be available.