Tag: vba
May 7, 2014
algorithms, code, code library, data structure, implementation, programming languages, sorting, VBA, vbscript, windows, windows scripting host
Among the simple sorting algorithms, the insertion sorting algorithm is my favourite. Insertion sort is simple to implement and gives an average quadratic O(n2) running time, like other simple …
This is one of my favourite useful tips in Excel. Sometime, you have a less-accurate data set with a lower resolution. However, partial data cannot be fit into the program. …
In VBScript, the values are dynamic typed meaning that the values can be changed at runtime for any variable. For example, a numerical variable can be converted on the …
Today, a friend asks me how to remove the unit from a column in Excel. The format of a column is like this 123.45 unit. The easiest way is …
You can easily use Shell.Application to invoke methods related to Windows such as minimize all windows. For example, if you require users choosing a folder you can invoke the method BrowseForFolder. The …
