skip to Main Content

VBA Developer

Are You Looking for an Experienced Freelance VBA Developer?

My name is Carl Nixon, and I have been a freelance VBA Developer for nearly 20 years. I have worked all around the world for businesses ranging from micro-businesses to global organisations such as Pepsico, Walmart and General Mills.

Carl Nixon

Your Search for A VBA Developer is Over

As a VBA Developer, I have helped businesses like yours save a lot of time, effort and money by automating and simplifying processes! Some of my clients have saved tens of thousands of hours of work through my work.

It is not unusual for people to underestimate the power of VBA development, after all, it’s just a language to write macros in, isn’t it?

At Excel-Expert we have developed VBA applications that look after hundreds of millions of dollars in hedge funds, process millions of leasing prices and model marketing strategies across the UK’s biggest supermarkets.

Far more than a macro that automates some mouse clicks!

Here are just some of the reasons why these companies chose to utilise a freelance VBA developer.

Rapid Prototyping

By utilising the power of VBA and Microsoft Office, we can rapidly prototype software tools and business processes in Office. If there is an element of the prototype that doesn’t work or you don’t like, it can quickly be replaced, allowing you to carry out more analysis of the tool.

Fast Development

By developing inside the Microsoft Office environment we can take advantage of the powerful tools and features already built into Office to speed up development times. Projects developed in VBA can be developed in a fraction of the time needed to develop in languages like Visual Basic, Python, or C++.

Flexible Solutions

VBA Can be used to access the features of Excel, Word, Access, Outlook, PowerPoint, and several other Microsoft applications. As a result, VBA programming can build flexible solutions by combining all their bests features. VBA Can also access some external applications, increasing its flexibility further.

Familiar Interfaces

Why re-invent the wheel? The Office range of products (Word, Excel, Outlook, Access etc) have interfaces we are already familiar with. We utilise and build upon these interfaces to build tools that are easy to navigate and intuitive to use – no matter what the end-users experience level is.

Data Compatibility

Microsoft Office has been around for over 2 decades, and in that time, it has been updated to work with every data type imaginable. It can now import a massive range of data types and connect to data sources of all kinds. All of which can be taken advantage of with VBA development.

Open-Ended

Unlike tools developed in languages like Visual Basic or C++, tools developed in VBA are not locked up in a “black box” that you can’t access or update. All of your development is accessible and updatable by anyone with the right skills. You will never be tied to one developer!

My Skills

Excel / VBA
90%
Process Automation
90%
Reporting Tools
80%
Business/Financial Modelling
80%
Data Wrangling
70%

VBA Applications We Have Built For Clients

As a freelance VBA developer, I have had the privilege of working on a wide range of projects around the world. They have ranged from simple quoting tools to tools responsible for hundreds of millions of dollars worth of transactions a year.

The tools I have developed have helped companies save time, money, and lots of effort. I achieved this by combining our programming skills with our knowledge of business systems and processes.

Hedge Fund Management Tool

A tool that collated the purchasing requirements across over 150 manufacturing facilities, and hedged all of the risks involved. The tool raised the required legal paperwork and monitored the hedging over the following years.

Centralised Purchasing Tool

Amalgamated purchase requirements of outlets across Europe and combined them with factors such as marketing drives and weather forecasts. This allowed our client to make more efficient and centralised purchasing decisions.

Lease Pricing Comparison Engine

Our tool gathered leasing information from dozens of leasers, covering hundreds of thousands of price combinations. It then allowed our client to identify and market the most cost-effective deals to their customers.

National Stock Management System

Our stock control tool allowed our client to monitor stock levels on their team of fitter’s vans. When their fitters returned to the depot replenishment stock would be ready and waiting for them. This maximised their fitting time.

Debt Management CRM Tool

This tool helped our client manage and automate the recovery of over £100m in debt. At key stages chase up documents were created or chase up calls were scheduled. This allowed their small team to deal with twice as many debtors as before.

Plus Much, Much More

We couldn’t possibly list all of our past projects here, especially not in any detail. If you would like to hear more about our past projects or projects more specific to your industry, please get in touch.

Going Beyond Excel

As a part of working heavily with Excel, it was only natural that I became involved with other technologies. As a result, I have some skills in;

  • Power BI
  • Python
  • PHP
  • SQL / MySQL
  • Plus many more

Getting Away From The Spreadsheets

I am a grandfather to an ever-growing collection of grandkids (6 at the last count) and they swallow up most of my time away from spreadsheets.

For as long as I can remember, I have been passionate about children’s causes and charities. As a result, I have;

  • Worked on the ground in Kosovo delivering aid and rebuilding schools.
  • Raised over £100k for a local children’s hospice by organising various charity events including the Welsh premiere of Casino Royale.
  • Been banned from Bulgaria for being an activist campaigning for children’s rights in Bulgaria.
  • Organised special advanced film screenings (Harry Potter etc) for terminally ill children and their families.

I am currently looking for ways to use the skills I gained in Kosovo on projects in the Ukraine. This is an ongoing project at the moment.

To keep the grey matter ticking over, I am currently working towards a BSc (Hons) in Computing and IT with the Open University.

The very little remaining time I have is usually spent video gaming – I have been a massive gamer since the 1970s. All of my grandkids are also gamers (well the ones that are big enough to pick up a controller are) so we have a fair few gaming nights together.

Call 02921 29 2235

Outside UK Call +44 2921 29 2235

Your Extra Peace of Mind

To keep your spreadsheets up and running, Excel-Expert offers a unique and free after-sales support package. Any snags found in the first 60 days are fixed immediately and for free. Should you find any bugs in our programming in the first 3 years they are also fixed for free.

60 Days of Free Tweaking

When you buy a new house, you get to produce a snagging list for the builder to put right before you move in. We do the same. Once you receive your completed project, you have 60 days to report any snags and we will tweak/fix them for free.

3 Years of Free Bug Fixing

Our coding carries a three-year warranty, and any bugs will be fixed free during that period. Just get in touch and will fix any issue as quickly as we can. (Just so you know, no one has ever needed to use this warranty).

Back To Top