What We Can Do For You!
- Form creation
- Customising toolbars
- Automation of common or repetitive tasks
- Linking to external data, 3rd party software and databases
- Web based data retrieval
- User validation
- Automatic creation of charts/pivot tables and reports
- Sorting and manipulating data
VBA Macros in MS Office
Excel and all Microsoft Office products include a macro language called VBA.
With macros we can create automated solutions to reduce man hours, validate user tasks and link your Office application with 3rd party products.
All Office products come with macro recorders which allow you to record a series of steps you would like to be able to repeat. In recording a macro, the Office product automatically creates the VBA code for those steps, but the macro recorder is just the tip of the iceberg.
It is also possible to create add-ins using VBA. Add-ins or global workbooks allow your macros to be available to all workbooks when Excel is opened. There are several ways to achieve this and we would be more than happy to point your company in the right direction.
Are your workbooks not functioning correctly under your version of Excel?
If you have macros in your workbook, it is likely that when upgrading or moving to 64 bit systems that some of them will fail. If this is the case, we can review and solve these issues for you.
We have Excel developers and programmers in most capitals and states in Australia. With their extensive experience, they can create solutions for your organisation that will allow you to automate your tasks and let you get back to what you are good at, your business!
When it comes to training, for many of our clients it can be a bit of a waste of time and money to attend a fully comprehensive course when their job may only require a small portion of the extensive materials covered. That’s why we offer task specific training!
Using remote access, we offer ongoing support and training, as required. We offer responsive, experienced, local support at your fingertips!