This is a complete Hash table implementation for Visual Basic 6 or Visual Basic for applications. It is a complete tutorial and explains exactly how a hashtable works and the design decisions that were made for this version.

Excel macro to group and count the number of items in a range of cells, delimited by the pipe character "|". It returns a summary of the items including a percent of total and count for each item found, plus a grand total of all items.

Currently limited to 100 items, simple becasue I didn't have the time to spend to get dynamic arrays to work.

Sample Data:
--------------
cat|dog|bird
--------------
cat|bird
--------------
cat
--------------
frog

==================
OUTPUT from =total(A1:A4)
==================
42.9% - 3: cat
28.6% - 2: bird
14.3% - 1: dog
14.3% - 1: frog
---
7

This is a cool function that lets you save MySQL query data to an Excel spreadsheet. This is good for taking a backup or if you want to change a lot of information fast, then re-upload it.

I will use the config.php and class.mysql.php files from MySQL DB Class with Extras, so please look at those also.

This is a function which generates random letters for password. Programers can use this at Microsoft Excel and so on.

This script is a simple macro program which recalculate selected cells in Excel.

This macro is recalculating selected cells with showing the progress bar in bottom status bar.

Progress bar example :

しばらくお待ちください。再計算しています。| ***_______ | 35% | 35/100 |