Search results

  1. S

    Compile generates old version of compiled Excel program

    Hi First of all, I like XLS Padlock a lot, great program! Now for my problem: Is there some place where I can setup the path to the file that has to be compiled. I’ve created a new version of my Excel model, but XLS Padlock keeps generating an older version of the compiled code. E.g. I have...
  2. S

    Relative directories issue - Thisworkbook.path not working from .exe

    Hi As per your email response: I see when I pasted the quotes into VBA off the forum (or the help file), they pasted differently. So I had to replace the pasted quotes with quotes from my own keyboard ("). (1) Didn’t work - (“GXLSForm.GXLSFormula”). (2) Worked - (“GXLSForm.GXLSFormula”). (I...
  3. S

    Compiling classes

    Ok, that’s fine, thx. Regards Spartan
  4. S

    Relative directories issue - Thisworkbook.path not working from .exe

    Hi I saw a work around in another post, which I tried to replicate. However, I’m getting a further error. Runtime error 424 Object required. The program gets crashes on the bolded line. I definitely have the COM reference in VBA ticked under tools for the GXLSForm Library. My code: Public...
  5. S

    Relative directories issue - Thisworkbook.path not working from .exe

    Sorry I see now a similar question previously. I will try that solution and continue on that thread if there are further problems. Kind regards Spartan
  6. S

    Relative directories issue - Thisworkbook.path not working from .exe

    Hi My original code has a VBA script, which references an .xls file in another directory using the “Thisworkbook.path” keyword. However, once I’ve compiled my workbook into an .exe, using Xls Padlock, and I try to run the .exe, the code attempts to access the workbook from the a:\ drive...
  7. S

    Compiling classes

    Hi G.D.G. Team I’m a new user and I’m investigating how the trial version of Xls Padlock works to see if it will suit our purposes, before we purchase. It looks good so far! I’m having an problem at the moment: In VBA compiler and protection, is it possible to compile a class? How would one...
Back
Top