ALMUC

29/08/2026

Workbook_Open() and Auto-Deleting file(s) in Excel VBA

Introduction This blog article shows you how to run VBA when the Workbook is open and it could be misused as a melware. Many Excel automation tasks need to run automatically when a workbook is opened. A common example is deleting a temporary file such as data.txt. However, developers often discover that Workbook_Open() does not execute as expected. This article explains the VBA code, how the Workbook_Open event works, and the most common reasons it fails....

Introduction This blog article shows you how to run VBA when the Workbook is open and it could be misused as a melware. Many Excel automation tasks need to run automatically when a workbook is open…

29/08/2026

Understanding File Encryption with Python and Fernet

This blog article shows you how to do fake ransomware using Python. File encryption is a useful way to learn how applications protect sensitive information. This small Python demonstration uses the cryptography package to encrypt the contents of data.txt and later restore them with a secret key. Although the project resembles one small part of ransomware behavior, it is intended only for controlled, educational use on files you own....

This blog article shows you how to do fake ransomware using Python. File encryption is a useful way to learn how applications protect sensitive information. This small Python demonstration uses the…

23/08/2026

Building a RESTful Web API with Java and Spring Boot

This blog article walks through a simple but production-shaped REST API built with Java 25 and Spring Boot 3.3.4. By the end you will understand every class, every endpoint, and the design decisions behind them. Table of Contents Project Overview Technology Stack Project Structure The Data Model — Task The Hello Endpoint — HelloController The Task API —TaskController…...

This blog article walks through a simple but production-shaped REST API built with Java 25 and Spring Boot 3.3.4. By the end you will understand every class, every endpoint, and the design decision…

21/08/2026

Automating Excel Column Comparisons with VBA

This blog article shows you how to Automating Excel Column Comparisons with VBA. An essential task in Excel data management is spot-checking differences between two columns. Doing this manually for tens or hundreds of rows is time-consuming and prone to human error. Visual Basic for Applications (VBA) automates this process cleanly. The macro below highlights mismatches between two columns by instantly changing the font color of conflicting entries....

This blog article shows you how to Automating Excel Column Comparisons with VBA. An essential task in Excel data management is spot-checking differences between two columns. Doing this manually for…

02/08/2026

Building a Simple CRUD API with FastAPI

FastAPI is a modern, high-performance Python web framework for building APIs, built on top of standard Python type hints. In this post, we'll walk through a small but complete example: an in-memory "Items" API that supports Create, Read, Update, and Delete (CRUD) operations. The Full Code import uvicornfrom fastapi import FastAPI, HTTPExceptionfrom pydantic import BaseModel app = FastAPI(title="Simple FastAPI App")...

FastAPI is a modern, high-performance Python web framework for building APIs, built on top of standard Python type hints. In this post, we’ll walk through a small but complete example: an in-…

01/08/2026

Building a Python API with FastAPI and PostgreSQL

This blog article should you the sample of Python Web API. Healthcare systems live and die by their data layer. When we set out to expose the Patients table from a PostgreSQL clinic database as a web service, the goal was simple: a clean, typed, testable REST API, nothing more, nothing less. Here's how it came together, and a few lessons learned along the way....

31/07/2026

How to Change All Yellow Fonts to Orange in PowerPoint Using VBA

Managing font colors across large PowerPoint presentations can be time-consuming. This article demonstrates a VBA macro that automatically changes all yellow-colored text to orange throughout a presentation. Why Use a VBA Macro? A macro can scan every slide and shape, locate yellow font colors, and replace them with orange in seconds. VBA Macro Sub ChangeYellowFontToOrange() Dim sld As Slide Dim shp As Shape…...

Managing font colors across large PowerPoint presentations can be time-consuming. This article demonstrates a VBA macro that automatically changes all yellow-colored text to orange throughout a pre…

29/07/2026

Enterprise Architecture for Agentic AI

Agent sprawl turns into risk fast – teams ship agents that behave differently, rely on unknown data and are hard to audit. A shared architecture pattern brings order, so governance, data and operations stay consistent as AI scales. Read the eBook, Enterprise Architecture for Agentic AI, to explore how to: Reduce agent sprawl. Standardise how agents are built and deployed, so teams don’t reinvent patterns in isolation....

23/07/2026

Java Updating Records the Right Way using Hibernate

This blog article shows you how to update the record using Java Hibernate. If you've worked with plain JDBC, you know the drill for an update: write an UPDATE statement, bind your parameters, execute it, and hope you didn't typo a column name. Hibernate offers a different — and in many ways safer — way to do the same job. The modifyProduct method below, taken from a small Northwind-database utility, is a clean example of that pattern in action....

This blog article shows you how to update the record using Java Hibernate. If you’ve worked with plain JDBC, you know the drill for an update: write an UPDATE statement, bind your parameters,…