Data Hiding

Data hiding is part of the process of removing complexity from programs. Any program in a business environment that does anything useful can easily have 500 lines to 20 thousand lines of code. Without using sound engineering principles most programs would become unmanageable. Data hiding is the term used for one of the good habits [...]

Tagged as: data hiding, Excel vba, Good coding practices, macro, macro writing, Professional programming, vba, writing solid code

{ 0 comments }

C # for VBA Programmers

So you know VBA but for some unknow reason you need a cut to the case guide to understand C# quickly. Here you will rapidly learn how to program C#. First thing to understand is the VBA has both subroutines and functions, most other programming languages just have functions. In VBA the subtle difference between [...]

Tagged as: business programming, C Sharp, C#, vba

{ 0 comments }

How to create a website from scratch

This article will cover the basics of website creation because it is a huge concept which largely can be broken into two parts depending on your objectives The technical aspects of website building this includes coding html, css, hosting, dns, wordpress The business aspects such as getting traffic (vievers) and converting that traffic into sales or [...]

Read the full article →

Excel 2010 Advanced Filter Tutorial

The Excel 2010 Advanced Filter adds database functionality to Excel, you can query by example and style custom reports with this feature. Excel Advanced Filter Data Structure To use any of Excel’s data features, the data that you wish to query must look like a database table, that is to say that it must have [...]

Read the full article →

Power Excel vba secret, avoid using select

I see it all the time, code that selects one thing, then another, then selects something else in order to navigate and write data in an Excel spreadsheet. Instead understand that the Microsoft Excel object model and your vba code will be more professional, robust and mantainable if you don’t select anything but instead interact [...]

Read the full article →

Is your site indexed by Google ?

You have put up you site or contributed to your blog. But you don’t yet know if it has been submitted to Google. In order to check you site ranking all you have to do is type the following into the search engine… site: yourdomain.com Google will then list in the serp (Search Engine Results [...]

Read the full article →

How to code a vba form without using global variables

Global variables ruin applications Here is how to code a form without using those dreaded globals. This is especially useful for forms that must appear in the middle of a running process, and that need to collect information from the user and then pass the user’s choice back to the calling code and continue running. [...]

Read the full article →