Frome Business Services
Computer image

Make your excel processes easier and more accurate with macros and VBA scripts

As well as helping our clients develop spreadsheets for everyday tasks, we also have extensive experience working with Excel 'programs' using VBA.

Macros are Excel programs at their simplest; just a series of commands such as keystrokes that you would normally input using your keyboard. How many times do you perform a simple repetitive task such as formatting a spreadsheet or setting up page layouts for printing?

The good news is that you can record these actions into an Excel macro. Once completed, you can then replay the commands with the click of a button.

Using VBA (Visual Basic for Applications) that is built into Excel, you can enhance the macros or develop a program from scratch to perform almost any task, including talking to databases (to produce reports, for example).

We can either help you with basic training, develop an application for you or even work together on your project in a 'workshop' environment.

We can work with you in Excel 2003 or Excel 2007. Call us to discuss the possibilities and how we can match your requirements.

Intuit .IIF imports