Search results

Wow! Thanks! Dan

In an older version of XLSPadlock, the default settings included the MAC address, which I found out changes if uses are switching from company VPN to other networks. I now use the default for the new version of XLSPadlock which works great. Hope that helps. Thanks Dan

No problem, thats kind of what i figured. Sounds good, thanks!! Dan

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...

Please disregard. It’s a matter of unchecking this: OR if leaving it checked, including proper usage of the setOption helper NOTE: if you are debugging/stepping through the code and mess up the setOption helpers by not including both of them, it will perpetually not work no matter what...

Any ideas why the companion file and vba code aren’t working? Thanks Dan

Good idea!

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...

yep. it’s fixed in v2019. Nevermind! Thanks Dan

Holy cow! I didn’t realize I’m using an older version. I will fix that immediately and retest. Apologies! Thanks Dan

2018.2 I didnt see how to view the log in the help pdf file. Thanks Dan

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 Frankschn, Could you put something in your Workbook_Open() event of your excel program that analyses when it should self destruct (so to speak)? Or perhaps put a date in a cell in some invisible back page that once the program detects the date is less than or equal to today then it erases...

Yes, i can do this and yes it does prompt for password but one cannot access the VBE. Thanks Dan

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...

UPDATE 2 I also tried putting the DLL files on the Main component. Did not copy these to the install directory at all. I tried running the installer as administrator as well. I also tried installing these DLLs to the %SYS% folder because the Paquet Builder website said that it can put...

UPDATE So, actually, PB seems to not want to extract the DLL files to anywhere. I set the DLL files in the Components to the %APPDATADIR%\GridTest\ folder, but it did not put these DLL files in this directory, so naturally it could not register them. Thoughts? Thanks Dan

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, Thanks for your info and 1st class support as usual! I ended up resolving this by using the Temp folder, however, the AppData would be a great idea also. Thanks! Dan

QUICK UPDATE I did some testing and sure enough, if I check this: then the function XLSPadlockAvailable returns False, and when it is unchecked, the function returns True. Is there another way to let my app have access to Program Files without opening as admin and thus ruining this function...