Four Elms Bookkeeping logo Four Elms Bookkeeping logo


Mudford, Yeovil, Somerset
telephone icon 01935 850807

Excel Macro Development

Do you regularly carry out the same calculations but using different numbers each time? Perhaps, for example, you calculate profits, expenses, wages or taxes due for different companies, clients or employees, using the same calculation method each time, but with different input figures. If this sounds like you then your work could be speeded up and automated by the use of Excel macros. Macros can also be used to produce accounts, employee timesheets or payslips and carry out other accounting tasks. In fact whenever a method of calculation can be specified a macro can be written to do the calculation. Tailored user interfaces can also be designed to enable easy input of your data and user-friendly display of the calculated result (see examples of VBA UserForms ). Macros can also be written to transfer the calculated data to databases for memory-efficient storage, including the free MySQL open source database. Accounting and bookkeeping is, of course, only one of many areas in which VBA macro software can automate and speed up computations.

What are macros?

Visual Basic UserForm for input of employee working hours Macros are pieces of software code written in a language called Visual Basic for Applications (VBA). This software extends the functionality of Microsoft Excel so that it carries out the exact calculations you specify. Macros can be attached to particular spreadsheets that you use and operated via control buttons (or "ActiveX Controls") embedded in the spreadsheet. VBA macros can also be made generally available for use in any spreadsheet you open. General use macros operate in a similar way to Excel's standard functions and can be programmed to activate by clicking a toolbar icon.

Example of Visual Basic Code written in VBA v8

Why use VBA macros?

Visual Basic UserForm for input and calculation of statutory benefits Excel is an application that is already present on an estimated nine out of every ten computers in business use. Therefore no new software licenses need be purchased and the VBA code is easily run on different computers. Staff are often already familiar with Excel so little training is needed to operate VBA macros.

Macros with other Microsoft Office applications

The use of macros is not confined to Excel. It can also be used to automate activities in other Microsoft applications. Just to give two examples, Microsoft Word can be programmed to produce individually addressed letters to customers or clients whose details are stored in a Word table or database. Or Microsoft Outlook could be programmed to execute a tailored mailbox cleansing routine written in VBA.

How we can help.

Four Elms Bookkeeping offers a competitively priced macro writing service. If you believe that macros tailored to your precise requirements could save you time and cost on repetitive data input or calculations then contact Four Elms Bookkeeping now to discuss your requirements.

Return to Home Page

Examples of Visual Basic Coding Projects

Installing an old Active-X control in Excel 2016

For help with Excel macros contact Four Elms Bookkeeping on 01935 850807.

Proprietor: Richard Waggett B.Sc., Ph.D., MICB, CBDip.,Dip.PM

2012 Four Elms Bookkeeping