Programming, VBA, Excel and Acces

  • images (2)
  • download
  • images (1)
  • full screen slider
  • f1f4fe59-9fbc-48b9-9757-d487811bde95-ServicePic
images (2)1 download2 images (1)3 full screen slider4 f1f4fe59-9fbc-48b9-9757-d487811bde95-ServicePic5
image carousel by v7.4

VBA (Visual Basic for applications)

In combination with Excel, Access etc.

VBA goes where regular Microsoft Office programs stop. If you are a regular user of Microsoft Office products, you'll find that you either repeating your actions, loose track or simply like to improve your views and inputs. Part of this can be done with Macro's (which are in a way a form of VBA). A lot of things can not. With VBA there are endless options of adapting your business software (ERP systems and others) with your own office applications. Importing data from your system and presenting them including dropdown menus, searchfields etc. The other way round and preparing data to be imported from a system or an external source to a next application is usually also possible. With VBA a XML-file, CHR or CSV can be prepared for import in other systems. Or sometimes even a direct connection can be established (ODBC) with options to read straight from external sources. All can be automated to a single click event. 



 Options are countless, so let us know what you would like to achieve and I will let you know if and how VBA might be able to assist you.

It works with all Microsoft Office Software, but I specialize in VBA in combination with Excel.



Building of sheets, Connected to database, Dashboards and more....

There's hardly any business in the world that doesn't use spreadsheets. For some it's enough to run their whole business, while other use it for ad-hoc reports, analysis of their database and so on. Of all spreadsheets, Excel is without question market leader. Competition even boasts that their sheets are fully compatible with Excel.

Even with such widespread use, a lot of companies don't have the knowledge or fail to realize (or have no time) to make a better use of Excel. Especially there were a spreadsheet is not ad-hoc (here training of users is normally more in place) but frequent, or non-existent but needed I can help you out. 

Experience in building sheet ranges from pricing models, production planning and scheduling (combined with data from ERP-systems if in place), investment return models, company forms, reports and dashboards. Automated import and enriched/updated export of data from and to other systems is a next field of experience. Altogether if you can state which input you have and which output you would like to have, I can tell you if the processing can be done through a spreadsheet. Rebuilding and updating existing sheets is of course an other option.

Why sheets ? Mostly because you already have the data and the spreadsheet provides a low-cost platform to individualize the way you want your data to be handled / processed. With standard of the shelf software you might miss information that is specific and might even determine the heart of your business. 



Database / Acces

Preparing of XML-files, SQL, your own application

Building a database goes a couple of steps beyond building spreadsheets. I normally will advise this if multiple users have to actively work with data (delete, alter and add). The first question in this case should not be, if and what it is going to take to build a database, but if it has of the shelf solutions that can cover your needs. Only if this is not the case data-analysis and blueprint making for a database should start. 

The above doesn't mean a database (Acces in my case) needs to be something complicated. If for instance you run a clothing store and want to administrate customer sizes in order to send specific mailings to customers of size 50, you might end up building your own application because you won't find something exactly matching. If your store has a single outlet a sheet (Excel) might be advised. If you have multiple outlets, connected through a network, a database will probably be more suited.

With both options - sheets and databases - most business problems and information needs can be automated. Whether you like it or not, I will be critical regarding your request. I don't blindly build anything  a client requests. If I see further improvements on your wishes I will suggest them to you. If I see wishes that are not businesslike (putting a lot of time in small details for instance), i'll advise you on this point. First and foremost I'm a business and ICT-consultant (MBA) and not a programmer.


Leave a Reply

Your email address will not be published. Required fields are marked *


This site uses Akismet to reduce spam. Learn how your comment data is processed.