Category: VBA
-
Formatting CSV files in Excel
As a csv file is a text delimited file it doesn’t contain any formatting. The process of formatting csv files in Excel is a repetitive process which is an ideal candidate for a macro. You can store macros you need to run on different excel workbooks in your personal workbook. This is a hidden workbook…
-
User registration using VBA and WordPress
wanted a simple method to allow user registration in order to advise of program updates. I created this plugin in WordPress to make a registration table and I have detailed below the VBA
-
DSNless Connection in VBA to SQL Server Tables
When we released updated access database which were linked to an sql source the deployment requires re-connection to the client environment ; We would need to ensure the client PC had the DSN setup and tested, to simplify the process we call this DSN-less function. The program tests the connection when opening and advises the…
-
SQL Update Scripts
In the absence of a UI for a given table, updates to records on that table need to be executed as SQL Update Scripts. This process would usually involve some development resource to create the script under the instruction of a given user. The obvious solution would be to add a UI to allow the…
-
Automating Test Data Loading
Part of the process of creating reports and reviewing the program design involves loading of test data. For the Club Lotto application I wrote the function below to load test ticket sales into the system.
-
Track Your Application Usage
When you release either commercial or free software its useful to be able to track your application usage by your customers to advise of updates or changes.
-
Printing Receipts to a Sewoo from VBA
For a recent project we needed to print receipts on a mobile sewoo printer. First we connected the printer via bluetooth to the laptop.
-
Offline Club Lotto Automation
Running a club lotto has always been a great way to raise funds, but managing it effectively can be challenging. To streamline this process, we recently introduced Lottoraiser, a dedicated software solution that allows players to participate in our club lotto online. With Lottoraiser, players can conveniently choose their numbers, pay through the platform, and…
-
Access Startup on Distributed Applications
When your distributed applications are sent to a wide audience the application may fail to start if the user has not trusted the application and allowed VBA. If your application is programmed to start a form that contains VBA the form may display but all the options will be disabled. To save on support time…
-
Clean QR Code Generator
I was using Canva to make a QR code on my poster but it was a redirect type. I asked Chat GPT for a solution :). While ChatGPT gave the options below the only one which was static was chrome but it has the dinosaur embedded. I did find this conversation on Reddit , which…
