Under continuous construction
Over the years, I've built up my knowledge of some of the inner workings of the MS Office Suite. I've built (and continue to build) a number of new tools for Word and Excel using VBA. Here, I'll share some of what I've learned, including the code and how-to instructions. My hope is that this will be a useful resource for others who are trying to learn VBA.
Although most of the tools here are straightforward code, some of them require the creation of a7:32 AM 9/16/2009 form in VBA,
which takes longer, requires more VBA knowledge, and can just be a big hassle. Tools marked with 
include the creation of a form.
MS Word
| Short-term Bookmark | Click one button to mark your place, move all over the document, and then click another button to go right back where you started. |
| ASCII Character Finder | Find the ASCII character code for any character you can create in Word. (obsolete) |
| Delete Hyperlinks | Remove all the hyperlinks in a document or all the hyperlinks in a selection |
| Follow Hyperlink | Follow a URL that isn't already styled as a hyperlink |
MS Excel
| CTIME: Convert time into a readable format | |
| Decimal Number Conversion Tools | |
| DEC2BASE | Convert a decimal number to any other base from binary to hexadecimal |
| BASE2DEC | Convert a number from one base (up to hexadecimal) into decimal |