Search results

Ok, solved. Syntax in VBA Compiler is slightly different than Excel VBA IDE. Once adapted, functions work well. Thanks for your help ! Best regards.

Similar error: I’ve changed the compiled sub, to fill cells inside the function: Yes, I know “Application.rSetDades” is weird, but :

I have an excel with macros that fills a range of cells with a recordset obtained from SQL Server database. This excel is working fine since a bunch of months ago. Now, I want to test XLsPadlock. Setting this code in VBA compiler: public sql_dataBase As String = "myDB"...