October 24th, 2016
October 11, 2015
first impressions Thin
2016

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
computer-mistakes
articles

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
vba2010
2010

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
vba2010
2010

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
vba2010
2010

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
vba2010
2010

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
vba2010
2010

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
vba2010
2010

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
vba2010
2010

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 ...