(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 mic_1.2.exe -del
Looked through the .xplp files and registry for Checkin_1.1.
When I rename Checkin_1.1 to something else, spreadsheet wants to save in Documents.
What am I missing? What am I doing wrong?
Nothing wrong, the EXE tries to set the default save directory to the previous folder chosen by the customer. If the folder is not found, it reverts to the usual Documents folder.
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 to the Checkin_1.2?
Is there a way to manually update the default save library? Could I have something in the code that is triggering it?
Can you try the following code?
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 “Save.” How do I hook it in?
Be sure to copy the entire code. The object is available only in the EXE form and will trigger that error if run in normal Excel if you don’t use the entire VBA code.
You can for instance call the routine with the Workbook_Open VBA event.
Instead of a full filename, you can also just try to specify the initial folder.
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{___} directory?
(redacted the ID)
Yes, the file saves are also referenced into this file. You can try to rename it to settings0.dat to see if it helps.
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 the old directory checkin_1.1. Must be somewhere else…registry? Search turned up empty.
Could you please take a screenshot to show us where you see the “The save still showed the old directory checkin_1.1”?
