079 597 8368

mel@f1solutions.co.za

Customised Development and Database Design  / Microsoft Office training /

Template and macro design

Many companies like using standard documents like standard letters, memos or file notes. We can program these standard document templates for you, as well as more complicated ones like the ones that are traditionally used in the legal industry, such as bills and statements.

A template can be as simple as a document containing pre-set information like company logos and address information, or it can be more complicated, with dialog boxes that pop up for the user to fill-in. The more complicated ones require an advanced knowledge of programming in VBA

Customised Excel solutions

We can program Microsoft® Excel to perform repetitive tasks using VBA code. The code can search thousands of rows of data and extract relevant information, perform calculations on this data and then return the answer that you require - all in the single click of a mouse!

Toolbars, menus and forms can be customised to suit your users. A complete office solution can be created specifically for your business needs.

What is VBA (Visual Basic for Applications)

VBA is the programming language behind the Microsoft Office macros - it enables you to build  custom solutions using Microsoft ® Word, Excel, PowerPoint, Outlook or Access - using the VBA language that is incorporated within all of them.