Excel - Automatically add footer





ranking Sort Sort   |   date Sort Sort   |   member Sort Sort
Syndication

0
Date Submitted Mon. Dec. 15th, 2008 6:57 AM
Revision 1
Beginner suin
Tags excel | Password | Random | VBA
Comments 0 comments
This is a function which generates random letters for password. Programers can use this at Microsoft Excel and so on.
0
Date Submitted Tue. Dec. 16th, 2008 11:26 PM
Revision 1
Beginner suin
Tags excel | macro | VBA
Comments 0 comments
This script is a simple macro program which recalculate selected cells in Excel.
0
Date Submitted Sat. Dec. 20th, 2008 3:10 AM
Revision 1
Beginner suin
Tags excel | macro | VBA
Comments 0 comments
This macro is recalculating selected cells with showing the progress bar in bottom status bar.

Progress bar example :

しばらくお待ちください。再計算しています。| ***_______ | 35% | 35/100 |
5
Date Submitted Fri. Oct. 27th, 2006 8:30 AM
Revision 1
Helper RobHarrigan
Tags count | excel | group | macro | tally
Comments 0 comments
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
5
Date Submitted Wed. Aug. 2nd, 2006 7:50 PM
Revision 1
Helper lgrover
Tags "Visual BASIC" | hashtable | tutorial | VBA
Comments 5 comments
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.
5
Date Submitted Tue. Sep. 4th, 2007 11:34 PM
Revision 1
Helper explode
Tags excel | mysql | PHP | query
Comments 0 comments
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.