Search results

Hi, Trying to figure out how to use VBA functions such as VBA.Left() or VBA.Split() The VBA compiler doesn’t recognize these and the documentation only mentions using Application dot (.), so is there a way to use in-build VBA functions other than using Application.Worksheetfunction functions...

Hi, When I open my EXE file and make a change and try to save, it always gives the following errors and will not allow saving, even though I have the settings for it to allow saving. See screenshots below. BTW, the markbook Demo from the XLS Padlock website saves perfectly, so I don’t know what...

Hi @gdgsupport and all, I’d like to allow my XLSPadlock locked Excel program to be able to utilize a dll file (with a COM/ActiveX control) without having to register the dll file. I’d like to see if the virtual environment within the protected workbook can utilize my activeX control file, even...

Hi all and @gdgsupport, I’m trying to perform a test to see if either variables are true or the value 1. My variables are %operaNoteBool% and %edgeNoteBool% I see that in my current test they are both returning zero (0), but my ‘Perform Operation on a Variable’ using varORBool is returning 1...

Hi All and @gdgsupport ! I’ve been at this all day and it’s time to ask for some help. I’ve figured out how to determine what version of chrome is installed by using: but then when I analyze the variable chromeVersion, I’m successful in setting the correct component variable based on its...

Hi @gdgsupport, Happy Tuesday! I had a student who is wanting to know if there’s a way to completely hide the File ribbon and the status bar entirely in order to give the appearance that this is a standalone application, independent of Excel vba. I’m curious if this can be done in a future...

Hi @gdgsoft and all, I tried executing an exe command, but it turns out I need Unelevated rights so the Exe file within Paquet Builder file will go to the AppData Local folder instead of Program Files. So I read in the documentation that I can use “Open the file” and check the Unelevated box...

Hello @gdgsupport and all, I was wondering if there’s a way to run windows API calls in the compiler (or some workaround to more easily conceal passwords in the vba compiler when connecting to something online via Windows API), such as ftp, online databases, etc? If I try any Private Declare...

Dear @gdgsupport and all, Is there any way to disable the tiny button at the bottom that when clicked allows users to record macros with the macro recorder? Also, I discovered that my app still has the keyboard shortcut Alt+F8 that still works. This would allow users to manually run any macros...

Hi @gdgsupport and all, In the XLSPadlock Security->Formulas and Passwords menu, the option “If your worksheets are protected with a password, please provide it:” sounds like it assumes that each worksheet has the same password. What if, for security purposes, one uses a different password for...

Hi @gdgsupport and all, I’m trying to get the companion files example from the help file to work, so I made a super simple workbook, named it “Test File.xlsx” and saved it in the EXE’s same directory. Tried to open it with code from the pdf help file (please note that I renamed the file...

Hi @gdgsupport and all, I submitted my file to Virustotal.com per one of the other blog posts about Norton or AVG throwing a fit with the program and I noticed it said my file is not code signed, which I thought was weird. It turns out, it was not code signed, even though I have the option to...

Hi @gdgsupport and all! I’m trying to show off the Markbook-Demo.exe, and the first tab says it is not preventing access to the vba and that the password is ‘1234’, however, Alt+F11 won’t work, right clicking on the tab to ‘View Code’ is disabled and there’s no way to add the Developer ribbon...

Hi @gdgsupport and all, I’m trying to add DLL files (ActiveX controls) to a %DESTPATH%, such as C:\Program Files (x86)\DanTest\ I have it release one of 2 components beyond the Main Component, depending on whether they have Excel 32 bit or Excel 64 bit (thanks to your help by the way!!). The...

Hi @gdgsupport and all, I was trying to debug an issue with my app so I enabled access to the VBE temporarily in order to step through. One problem I’ve never experienced before was that the app didn’t know that it was a protected app. When I tried this function, it was returning False even...

Hi @gdgsupport and All , YOUR SOFTWARE IS AWESOME! I do need a bit of help please. I’m having trouble making a quick copy of a sheet and then saving that file. I used to use secure save files, but this app I don’t actually allow any saving, they always load the ‘Original’ version each time...

Hi @gdgsupport and ALL, When trying to play with the VBA compiler, I was following the steps outlined in the video here: and when I tried to run the =ten() function on a worksheet cell, it gave me this error: This error occurred in the VBA compiled code: “Access violation at address 221F6B92...

Hi @gdgsupport (and All), I need help figuring out how to determine whether a user has Microsoft Excel installed as the 32bit Excel or the 64bit Excel, so the installer will go a different route in installing things. Can anyone help? I see there are system variables such as #IS64OS, but I’m...

Hi @gdgsupport, Is there a way to make a big gaudy flashy popup prior to people installing new version of an excel application (xls padlock application). Such as a messagebox or something to warn them: “WARNING: Did you perform a backup on your previous version of XYZ Application? If not...

Hi @gdgsupport, I’ve had a few instances of people accidentally overriding a lot of data and losing all their excel database when opening the program. When people open my application and click ‘Original Workbook’ (instead of clicking ‘Last Save’ like they’re supposed to) and then they select...