Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
551 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
When Wise Owl get to the pearly gates and we are asked what is the one thing we've accomplished in life, the answer will have to be: becoming expert in VBA.
There are many things wrong with this analogy, not least of which is the shaky concept of a company going to heaven or hell when it dies.
To see the depth of our knowledge of VBA, have a look at our online tutorial, or take a look at our Flappy Owl game (written entirely in Excel VBA). Here's an excerpt from the latter, showing how beautiful VBA can be:
Public Sub UpdateAndDrawGame()
'Runs once for each tick of the timer clock
'Updates all game logic
'Draws all game objects
Bird.Update
Wall.Update
Bird.Draw
Wall.Draw
'test for collisions and exit the game
If Bird.Colliding(Wall.TopWallRange, Wall.BottomWallRange) Then
TerminateGame
Exit Sub
End If
End Sub
Here are some examples of systems we've written using VBA:
Software | System |
---|---|
Excel | Umpteen models and systems with back-end VBA to control user input, forms and navigation. |
Access | Databases to manage membership systems, libraries, expenses, stock control, accounts, and many, many more. |
Outlook | We don't claim to be experts in Outlook, but we have written systems to manage incoming email and to run email mailing systems. |
Word | Our manuals system is replete with macros to automate tasks (although Word VBA can cause migraines ...). |
SharePoint | We've written copious macros in SharePoint Designer, automating the production of web pages. |
If you want to draw on our expertise, whether to find out if your plans are technically possible or you want to commission a full-blown system, let us know what you have in mind and we'll do our best to help you - without pestering!
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.