VBA

The programming language for Office.

We can train you if you are going to be carrying out a lot of VBA development yourself.

• Learn the fundamentals.
• Find out what you missed by learning it on your own!
• Discover where it fits with VB and VB.NET.
• Learn for use with just one program - Excel, Access, Outlook etc.
• Learn how to send data to and control other Office applications from another.
• Find out how to maintain security from viruses but stop the warning message from appearing all the time.
• Discover other resources you may find useful.

If you think that you need to have some automation but that is likely to be a 'one-off', the investment in your time to learn this may not be economic. So you may be better off using an Office developer to do it for you.

An example of what can be done is this:
The company had been making extensive use of spreadsheets for a few years but were now moving to using a database. They wanted to migrate the data from Excel into the new system. Unfortunately simple copy and paste wouldn't do it! They also had lots of spreadsheets and needed to transfer the data over a 'go live' weekend.
We built an application in Access that allowed them to choose one of their spreadsheets, click a button and it all appeared in their database! We had to build in lots of checks to ensure the data in the spreadsheet was vaild, convert columns in Excel to rows in the database and do calculations, the results of which were written to the new tables.

Excel VBA

You may want some code written to automate Excel. Whilst we can train you in how to do this yourself, frequently your requirement is just to have this feature written then use it. If so, using an Excel developer is more economic.

Word Development

Whilst the VBA code can live in just one application, we frequently 'drive' Word from a different one. An example is to create Word documents to print and send from data in Access. The button in Access starts Word and creates a document. The benefit using Word is the power available to format the document.
One of our manufacturing clients now has a system that produces paper forms that machine operators take with them. Another used our Word development skills to have acknowledgments generated for payments received and contracts created for the property their clients buy.

Here's another example that a Word developer can create.

PS. By the way... it stands for Visual Basic for Applications!

Call 01604 879505 to discuss your requirements   enquiries@blackmanassociates.co.uk 
Based in Northampton in the UK and working with companies worldwide.