Search results

Hello I currently use XLSPadlock and Paquet Builder via Bootcamp on a MacBook Pro. However if I upgrade the new Mac’s they don’t use Intel and therefore Bootcamp not available. The option is to use Parallels Desktop. Has anyone experience is using either products in that environment and able to...

A few general queries on this topic: Is it possible to pass a complete sub routine to the compiler? Is there a limit on the size of code that can be compiled? If a sub routine uses functions should those functions be put through the compiler first? Thanks Dave

Hello Would it be possible to design the unlock keys such that they can determine which features to unlock in a compiled XLSM file? In other words, by way of example, the unlock key (or components thereof) would be checked by the VBA and the OfficeRibbonX editor would be used to enable or...

Anybody finding perfectly working xlsm files suddenly finding the code cannot be reached and the code unviewable despite the modules showing up in the Project Viewer? It probably isn’t an XLS Padlock issue but any thoughts welcomed. For clarity the security settings do allow macros to be run...

Hello Anyone come across the following problem and managed to resolve without resorting to checking the box “Use Excel automation for formula protection” [Security/Formulas and Protection]? In my example the table column does not appear in the stated table and to my knowledge, after checking...

Hello Does anyone know either how to allow the user to prompt for the other OLE action to be completed. It occurs when the VBA code is calling Outlook in order to send emails. On some rare occasions I’ve seen a dialogue box appear – but so rare I cannot remember what it was about. However...

Does anyone know whether UK Banks operate a standard approach to allowing API or do they each have their own structures? At the moment I am put off finding an integrated Excel solution on the basis that each UK Bank has its own method and thus you’d need a solution per bank. But that is just an...

Hello all Can anyone advise whether a) Executable (exe/xlsc) files can reference a OneDrive path and thus save output files there and b) Can EXE files be run from the OneDrive directory. My presumption is no in both cases. Thank you, Dave

Hello all Just spotted this feature to notify users of upgrades. There is a “Generate Web Update Files” but have two questions: Does this mean the Paquet Builder option is not needed for the upgrade? Will the routine allow for both the exe file to be code signed and will the “CAB” file also...

Hello all Section 9.1 of the manual says this is the default method especially when the user makes lots of changes. It says the main drawback of this method is that when you deploy an updated EXE file, xlsc save files previously made by the customer will not be automatically upgraded and they...

Hello all Is it possible to access data from a compiled WorkBook? If for example WorkBook B (xlsm) reads from tables in WorkBook A (xlsm) but then WorkBook A is compiled into its executable (exe) - presumably access is lost. I have solved this issue by extracting the tables from the compiled...

Hello I have the xlsm version allowing the user to access the Review Ribbon and the Protect Section to allow them to unprotect sheets. However when this is compiled via XLSPadlock to create the executable (exe) this Protect section is greyed out for both the Sheet and Workbook protection. How...

The following applies to both XLS Padlock and Paquet Builder. Although I have become accustomed to this I wonder whether there is away to prevent it. When going through the compilation of either the XLS Padlock exe or generating the package there will be a series of request for the Code Signing...

If I create a Workbook called WB1.00a.xlsm and compile it into an executable and then realise I want to make a change I am getting annoying results. I will go back to WB1.00a make the necessary change; save it (still as WB1.00a) and then re-compile into the executable. However when I open the...

Hello I would like to use GConvert 5 to create an EXE icon from a png (or other formats). Is there a recommended size to be used for the output icon please? Thank you Dave

Hello I was testing out some code to to automate a SAVE AS routine via the RibbonCallbacks. After making some changes and recompiling the exe file I found the changes appeared not to be working. However I then accidentally discovered that when I re-opened the application using the original...

Hello Has anyone here used MZ Tools? It promises to do everything you would want it to do but after downloading a trial version working out how to use it is challenging and the user guide generally just says what you can do rather than how to. Am sure it shouldn’t be this difficult. I did find...

Hello, hope someone may be able to point me in the right direction to solve: A routine is being used to export tables to an external workbook. The routine works successfully in .xlsm format with either “ThisWorkbook.Path” or its XLSPadlock equivalent function. However in the compiled .exe...

Hello I know this isn’t quite in the right domain to ask but hope someone may have had similar needs and know the answer. I have a code signing certificate but in some cases would like to sign an .xlsm file rather than either code sign the exe or even a code signed installer via Paquet Builder...

Good afternoon everyone. Has anyone come across the situation where left hand menu item of the Paquet Builder application has such a large font that it does not display properly in the available row width. Please see attached file (if loaded properly). Unfortunately makes it very user...