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:
PowerPoint Intermediate Advanced
I just wanted to give some feedback for Richard. Richard provided an excellent well- tailored two days course. It was clear that Richard was well prepared and checked MetLife webpages to understand what type of imagines and presentation packs we use. He also tried to understand from the individuals their day to day issues. The sessions were fun, structured and informative.
Prudential Plc C/o Corporate Property
Strategy & Service Planning Assistant
I attended this course to get a refresher on some of the things not covered on the advanced course, particularly around formatting. I found it really useful and the trainer was very friendly and patient with the group.
National Police Improvement Agency
Finance Business Partner
Excel VBA Intro Intermediate
Excellet course with dedicated tutors that want you to understand the course contents not just wrote learn from a powerpoint presentation. each student although in a class of ten is felt to be as important as the next person and given any help required.
Would suggest extending the course by one day to include more on pivot table or other things not included such as heat maps etc. This could also be assisted by moving at a slightly faster pace.
Getting students to write in with a practical problem up to two weeks before the course, so a real life example can be used.