This macro will add a footer to your Excel worksheets. I use this at work because every Excel spreadsheet I do has to have my department and initials in the footer. This macro checks to make sure you are the author of the workbook, and it will not overwrite an existing footer. Just place this code in your personal macro workbook in the ThisWorkbook object.

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.

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

A simple HashTable Function in VBA, incl. checking for unique key.

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 |