Search results

  1. S

    Save during execution defaults to old directory

    In the C:\Users\micsg\AppData\Roaming\XLSPadlock\UserApplication directory, there were about 9 directories, each with a different GUID. I moved all of those directories somewhere else. Opened XLSM, compilted it, then exited. I then opened up the .exe file and tried to save. The save still showed...
  2. S

    Save during execution defaults to old directory

    If comes up with the correct .exe path. I even shoved a MSGBOX in to confirm. When I try to save, it still goes to the obsolete path. Is there a true “Set” function? Did a little research. Could it be the settings.dat file in the C:\Users\micsg\AppData\Roaming\XLSPadlock\UserApplication{___}...
  3. S

    Save during execution defaults to old directory

    Will do. Tried the test with the subroutine … Ran debug It gave me a “Subscript out of range” error on the following: Set XLSPadlock = Application.COMAddIns(“GXLS.GXLSPLock”).Object The routine would surely need to be called when the user clicks “Save” or closes the workbook and selects...
  4. S

    Save during execution defaults to old directory

    I haven’t used that previous folder (“F:\VBA Projects**Checkin_1.1”) for several weeks. It keeps reverting back. I’m up to Checkin_1.2 and had to manually save there. I understand Documents is the default if it doesn’t find the folder. This Checkin_1.1 is kept somewhere. Why would it not update...
  5. S

    Save during execution defaults to old directory

    (XLSPadlock downloaded a couple of months ago; love the product). Loaded.exe file by double clicking on “F:\VBA Projects\Checkin_1.2\XLSPadlock_2022_0122\MIC_1.2.exe” Click File, Save MIC_1.2 Spreadsheet wants to save in “F:\VBA Projects**Checkin_1.1” directory as a secure Excel File. Did...
  6. S

    Limitations on VBA in compiled format

    I’m running into some challenges when I move code from Excel’s VBA to XLSPadlock VBA. The “_” flags an error when used on continuation statements. Is this a restriction? MSGBOX apparently needs all parameters. “, ,” generates an error. When I attempt to save, I get an “Internal Error Unable to...
Back
Top