Thethinkbox - thethinkbox.ca - Thinkbox
General Information:
Latest News:
Photos: Calgary, Canmore, High River Worst Flood in Decades, June 2013 21 Jun 2013 | 09:13 am
Some photos from the flood in Canmore, Calgary, High River and other places affected, June 20th 2013. Canmore, Highway 1 Highway 66, Bragg Creek area, on the way to Elbow Falls Canmore Canmore Ca...
How to avoid Paypal currency conversion / foreign exchange fees on eBay for international purchases 15 Jan 2013 | 11:15 am
By default, Paypal really wants to do the foreign exchange for you because they make a few percent off your purchase like most other banks and credit cards. Below I explain the steps required to avoid...
How to fly and store your motorcycle overseas for touring, without using a shipping company, cheaply 19 Nov 2012 | 10:30 am
In this blog post I will explain the steps required to ship your motorcycle overseas yourself, registration and insurance and all that kind of stuff, step by step, it’s not difficult. Using specialize...
Fast copy an Array (or text files) directly to a range of cells in Excel, VBA macro code. 19 Nov 2012 | 01:58 am
In Excel it is much faster to write large sets of data to a spreadsheet all at once instead of using a loop, by copying an array variable to a range of cells directly. This can speed up an Excel macro...
Speed up Excel VBA macros by turning calculations off and on 19 Nov 2012 | 12:23 am
In large Excel workbooks when you are executing VB macros that change cells in sheets, you can speed up the process significantly by turning workbook calculations off at the begining of your subroutin...
Excel, VBA macro functions to convert column number to letter, or letter to column number 19 Nov 2012 | 12:13 am
I’ve tested these in Excel 2010 in sheets with over 16,000 columns and the functions work even for large numbers of columns. Function ColumnLetterToNumber(ColumnLetters As String) As Long ColumnLetter...
How to copy an Excel Worksheet with Forms to another workbook without external references 18 Nov 2012 | 11:53 pm
The trick is to replace all of your “Form Controls” with “ActiveX Controls”. In the Developer toolbar in Excel they appear below the Form Controls. The differences I have found: When copying a sheet w...
Defining global variables, and arrays of unknown variable length in Excel macro, VBA 18 Nov 2012 | 10:59 pm
It’s not usually recommended to use global variables because they make it more difficult for debugging or reading other people’s code. However, they are handy sometimes when you’re in a rush to get y...
Switching between HTML and Visual editor in WordPress, without messing up your custom HTML code 18 Nov 2012 | 10:48 pm
Preserved HTML Editor Markup is your solution, it is a plugin that preserves your custom HTML code. By default WordPress’s TinyMCE will often mess up special HTML tags you use when you switch to the ...
Free Batch Renaming application, for Windows 18 Nov 2012 | 05:15 am
Batch rename files in a directory you specify in Windows, for free! I programmed this little application. Just specify the directory path location of interest and this application will allow you to s...
