October 11, 2015
Office 2016 – First Impressions
Upgraded to Office 2016 today and just wanted to share my first impressions of the new features. Highlights are: Uninstalled 2013 which I was very unhappy about since it ...
April 30, 2014
5 Common Excel Noob Mistakes
There are many things that almost everyone, including myself, did when we first started using excel that are massively counter productive. Hopefully you are reading this article early in ...
March 23, 2014
VBA 2010 – 079: SQL AND
How to combine multiple conditions together in your SQL query in order to bring back records with multiple filters. Download the samples for this series for free! All our ...
March 23, 2014
VBA 2010 – 088: SQL JOINS
How to join different tables together in your SQL Queries Download the samples for this series for free! All our tutorial samples are free however if you appreciate our ...
March 23, 2014
VBA 2010 – 099: GetOpenFilename
How to open a dialog box allowing the user to select files. This in turn is given to your code so that you can work with the selected files. ...
March 23, 2014
VBA 2010 – 114: Creating a SQL file
How to create a SQL file in order to drop data into a database or create a database backup. Download the samples for this series for free! All our ...
March 23, 2014
VBA 2010 – 113: Creating a HTML file
How to create a html file from your vba to produce a webpage from excel inputs. Download the samples for this series for free! All our tutorial samples are ...
March 23, 2014
VBA 2010 – 112: Creating a text file
How to create a brand new text file. Download the samples for this series for free! All our tutorial samples are free however if you appreciate our work and ...
March 23, 2014
VBA 2010 – 111: Adding Data to a Text File
How to add data into a text file. Download the samples for this series for free! https://www.youtube.com/watch?v=9Q1KRZAfnE0 All our tutorial samples are free however if you appreciate our work ...