VBA Programming
Support Logix
Support Logix programs in Microsoft Excel® and Microsoft Access® Visual Basic for Applications (VBA) for Companies, Organisations and Government entities.
We have completed work in VBA programming for District Health Boards, Manufacturers and Local Government to name a few industires however we can provide solutions in any industry and would
welcome queries from your industry. We specialise in Microsoft Excel® and Microsoft Access®. We also provide support in Microsoft Excel® in advanced formula work.
Here is a list of topics of when a Visual Basic for Applications Programmer can save you time and money.
-
Cost Save - Much of our VBA programming is done for Cost Save purposes. Where a manual process around data entry can be automated by programming. We have literally saved firms countless hours
in saved time per month and year. Making the return on investment very high.
- Creative Solutions - Our programming can be innovative and we just need to know what problem your trying to overcome and we will formulate a solution for you.
-
Dynamic - We have completed VBA Programming tasks like the mass updating of Workbooks used as File Records, updating a Version of a Workbook
across multiple folders in a fully automated process that can typically be run overnight when users aren't using the files. We have added VBA modules and more functionality to
existing workbooks with a mass update.
-
Information Consolidation - We can scan workbooks instead of linking to hundreds of individual Microsoft Excel® Files, we simply scan for
specific information and then update a data repository or server for business intelligence analysis or general reporting purposes.
-
Make a Workbook User Friendly - Support Logix can add VBA Objects like Forms, Message Boxes, Input Boxes and Alerts to guide a User through a complex Workbook and
add in data validation tools within the process of using the Workbook.
-
Financial Reporting - We have created user specific reports from ERP Software reports, altering the standard report and adding in other information to
report on both financial and quantitative information sets to add value for management meetings.
-
Change a Format of a Report - We have changed a report from a Horizontal configuration to a Vertical Configuration and completing formatting and data cleansing in the process.
-
Change the structure of a Workbook - Support Logix has written code to re-index Worksheets after a new record has been entered for example, so they stay in alphabetical order.
-
Data Migration - We can write code to extract data from Multiple Workbooks and upload this to a server. We can also cleanse data and manipulate data so its in the right format
for a new software application.
Support Logix provides Microsoft Excel® and Microsoft Access® VBA programming work from local companies and organisations in New Zealand and Microsoft Excel® work from International companies and organisations.
Contact us today to discuss a project where Support Logix can help.
For international clients you can email your Microsoft Excel® Spreadsheet via our email address on our Contact page, write a good description of what you would like us to accomplish. We
will review the work and decide whether we can take the project on. We will outline project milestones and might stipulate a payment be made on conclusion of each milestone. Payments can be made
by returning to this page and using Paypal below or we can send you a Paypal Payment method Invoice. Support Logix looks forward to being of service for you.