Visual Basic Code

Readiness Toolkit assesses compatibility for Microsoft 365

The Readiness Toolkit for Office add-ins and VBA can help you identify compatibility issues with your Microsoft Visual Basic for Applications (VBA) macros (sub procedures), custom functions and add-ins that you use with Office. The Readiness Toolkit includes the Readiness Report Creator, which creates an Excel report with VBA macro compatibility and add-in readiness information[…]

Lenovo Laptop View

Remote Learning and Support

*** 18th March 2020 *** Due to official advice on social distancing to limit the spread of Covid-19 we are temporarily suspending our face-to-face training delivery to focus on Remote Learning and Support options – our development projects continue and we are expanding our live streaming interactive virtual classroom sessions and online customer support. All our[…]

Microsoft Visual Basic

Some Visual Basic Programming Design Standards

Visual Basic Programming Design Standards Visual Basic Programming Design Standards for coding aren’t about rules that have been set in stone, they’re about practical guidelines that in the end will make your life as a programmer easier and your programs better. The intent in presenting this content isn’t to hand down a set of programming[…]

Microsoft Excel

How robust are your Excel Spreadsheets?

Most businesses use Excel, it is an essential tool in the modern business world. But many people admit to knowing only a small amount of what it can do. Do you have Excel questions you’ve always been afraid to ask? Are you perplexed by IF Statements, VLOOKUP and INDEX MATCH? Would you like to get[…]