Having recently discovered some great tools for UPnP (formerly by Intel, now open source), I wondered whether it was possible to create some gateway. I like xPL for its simplicity but its definitions of devices (schemas etc.) are still fairly ambigious. Thats what I like about UPnP, much tighter descriptions, more solid enduser experience. I think this is why most of the xPL users are fairly technical guys that mostly build their own applications and script the whole thing together. A non-techie wouldn’t last very long out there. Continue reading
This is a similar piece of code as the ExcelSettingsStack posted earlier.
It does pretty much the same thing, but has some differences due to Excel settings being read/write and Access settings mostly being write-only. It provides the same two base functions; Push and Pop. The Push function stores the provided settings (or current settings for all optionals left blank) and sets them. Upon Pop, the previous settings on the stack are restored. If settings are write-only, the previous value on the stack is used as the current setting. The current setttings can be retrieved through the Last property.
Often if procedures are called from existing code they change these settings, which makes it hard to track the current settings when a call returns. This code provides a stack to be used for Excel Application based settings, it provides two base functions; Push and Pop. The Push function stores the provided settings (or current settings for all optionals left blank) and sets them. Upon Pop, the previous settings on the stack are restored.
Modulo 11 is a method to calculate checksums or verification digits to numeric data. Its used extensively throughout the world in cases such as bankaccount numbers, creditcard numbers, ISBN numbers and the like. The basic idea is not as much encryption or something similar, but more a protection against human errors. By calculating and verifying the checksum you can quickly detect cases like changing a single digit, switching digits, missing a digit, etc. By verifying a number as early as possible, you can decrease the amount of rubish entering a business process, and hence ease operations.
Here’s some code that I’m pretty proud of, its a nifty piece of code that allows to store any kind of data in a simple textbased container. It uses a custom Base64 encoding to store integers, floats, strings, booleans or blobs in a text block and adds some CRC checks and even some repair capabilities.
In VBA you may occasionally want to store some settings outside of the document. The registry is one way, but I often try to keep it in INI files as automated documents get spread through email easily, but usually do not get ‘uninstalled’ hence the settings will never be cleaned up. I’d rather leave an orphaned file than polute the registry. Other advantages are that its easier to support because a user can email them, or its easier to edit by a user.
Here’s another post of something I created long ago, yet never got to post. Just trying to catch up here 🙂
While looking for a control myself to achieve this, I couldn’t find any. Some VB6 controls we’re available, yet when distributing spreadsheets or databases I just don’t like to create to much dependencies on external controls. Quite often the support required goes through the roof when external dependencies are used.
Often if you create an Excel workbook with some automation features, you want to make sure that users enable macros to be sure the workbook behaves as designed. You can built in as many verification features as you want, but if the macros are disabled, they just won’t work.
After some serious bug-hunting today, an updated version of the xPLLib and an updated SMS application.
The SMS application remains functionally the same, it only uses the updated xPLLib to fix a bug and last weeks updated xPLCheckPackage.
The xPLLib has 2 updates, one being the bugfix, the other is an extension that enables the download and parsing of xPL vendor plugin files. Check the xPL page for the details and downloads.
An updated version of the xPLCheckPackage has been released (version 1.3). It fixes two bugs, see the xPLCheckPackage page for details and download.