98.9% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
Make Office work for you with VBA
Sun 28th June 2009
No question, then, that Office as a whole gives a very powerful and wide-ranging functionality to your organisation's needs. However, as powerful and versatile as it is, the suite still has inevitable constraints. Microsoft have designed their software to provide effective solutions for users in a huge - but not unlimited - number of circumstances. But they could never design it for YOUR circumstances; the software could never be built around your particular demands, it could not be created with your individual needs in mind.
Or could it?
An office suite that fits you in particular is not as unlikely as may seem. Indeed, not only is it possible, but it can be done with some ease, thanks to Microsoft's Visual Basic for Applications (VBA). As a tool for replacing uniformity with individuality, VBA offers tremendous flexibility in enhancing and easing the user's experience of MS Office, particularly Excel, Word and Access.
If there is a task that you need to perform regularly, you can create with VBA a small program - a 'macro' - that will automatically run through the process for you, increasing the effectiveness and precision of your work, and saving you a great deal of time along the way.
For example, if an organisation regularly produces a large number of letters through Word, those letters may well have details that crop up time and time again - addresses, perhaps, or general information - and countless hours can be wasted entering this information over and over again. Or an Access database, or an Excel spreadsheet, could require certain entries to be included repeatedly. Using VBA, these processes can easily be automated, while still maintaining your own individual requirements.
This, then, is the key to VBA, and the role that it can play in improving your work. It's certainly true that there are many things included within MS Office applications that can make tasks run more smoothly - but they aren't designed to fit your own particular needs. VBA makes this software run just as you require it to.
Ah, but programming - that would be the realm of the computer wiz, the fellow in the darkened room, oversized monitor, thick glasses and doughnuts, understanding more about the inner workings than ordinary people could ever want to, wouldn't it? Certainly 'programming' can be a daunting word, sufficiently so that many of us turn off at first mention. Yet it needn't be so; though there are indeed many programming languages out there of great complexity, there also exist languages aimed at the non-expert, non-technically minded amongst us, languages designed to allow us to dip in to easily understood programming as and when we need to.
This latter category is where one finds VBA. What first strikes the eye about the language is that, well, it's a language. More specifically, it is plain English. 'Programming' seems far less daunting when set in such simple, comprehensible terms - instead of rocket science, VBA offers the opportunity to build simple programs of your own, to fit your own needs, in a short time and with little or no expertise. VBA can be picked up very easily indeed, although a short training course can help you get the most out of it.
There's really no reason not to take advantage of a simple (and free!) tool that can dramatically improve your use of Office in so many ways.
Original article appears here:
London's widest choice in
dates, venues, and prices
On-site / Closed company:
The trainer was very patient and helpful and elaborated on any questions that were raised very well with great examples. I was very impressed on what I have now found Excel to be useful for.
Excel VBA Intro Intermediate
Excellent. Myself and 2 colleagues had STL visit us for on-site training for the Excel VBA 2003. We all had different requirements and the course covered a wide variety of topics, with good practical examples which made the learning more contextual.
The trainer was receptive to our learning styles and measured the pace accordingly. The course was good value for money, and when you consider that there are complementary places available following the course, this really helps persuade whoever is paying the bill that it is money well spent!
Siemens Shared Services
Very imformative and well presented. Trainer was very knowledgable and easy to understand.