|
I have written and designed countless VB6, VB.NET, VBA applications for private, public and company use. Here are a few of my favorites which have proved useful to friends, colleagues and netizens alike... if you have any comments, suggestions or requests please feel free to contact me.
|
|
1 - A quick fix for formatting Sunny's shop direct orders
NB. If file downloads as zip file just rename to "xlsm" before trying got open.
| shop_direct.xlsm |
Found this on the web just before I sat down to write one myself!
| Rename files.xls |
A collection of useful functions and procedures (last update Nov 2010).
| mikesvbadrawingboard_v1.xls |
Splits an Excel spreadsheet into sperate sheets for groups of data. Even copies headers!
To install
Excel 97-03: Save to your computer and click tools>Add-Ins>Browse>Click 'yes'
Excel 2007: Click the circle>ExcelOptions>Add-ins>Manage Excel Add-Ins>Browse>Click 'yes'
To use: open you spreadsheet and use "control+R" to run.
| Sheet splitter.xla |
Works like a vlookup but without the formula. Use this when your spreadsheet is
dying under the weight of vlookup statements. The results are non-dynamic.
| Manual vlookup.xls |
A toolbar especially designed for MI analysts who regually manipulate and analyse
large amounts of data. Includes delete duplicate, transpose, remove '#N/A' and other
special formating tools all at the touch of a button.
| Excel 97 toolbar.xls |
Spreadsheet based solver, uses multiple logic algorithms to offer hints and solutions to
the Japanese Sudoku puzzle. All hints and solutions are based purely on logical
conclusions with no guesses or assumptions.
| sudoku solver.xls |
8 - Speller Plus
A spelling practice program based on a spreadsheet. Has lots of options to test in
groups or worst spelt words. Not error trapped as I wrote this for personal use. First
version Feb '09 (last update Apr '09)
| speller plus.xls |
9 - Bell Chime
Written while teaching English in South Korea. The school I was working in didn't have
a bell system but each class room has a PC with speakers. This allows up to 8 alarms
to be set to ring indicatin the start and end of each class. There are resident sounds
but also sounds can be imported. First Version Jan'08 (last update June '09)
| bell chimer.zip |
10 - "Freestuff" checker
Autochecks a popular freestuff websites for a wish list
| Checker.xlsm |
11 - Speed and Efficiency Tips
What a difference a few calculations make!
Application.Calculation = xlCalculationManual
Application.Calculation = xlCalculationAutomatic
(Thanks Kevin Roper! - Mike's local copy)
12 - Batch convert from .xls to .xlsm
| convert_from_xls_to_xlsm.xlsm |
13 - Mortgage calculator - what can you afford to buy?
| mortgage_-_what_can_you_afford.xlsx |
14 - RAG (red / amber / green) topic tracking tool (PowerPoint)
| rag.pptm |
15 - BlackBerry SMS csv file merging tool
| bb_sms_file_sorter.xlsm |
16 - Email follow up
| email_reminders.txt |
