Excel

There are many tools I use and have developed within Excel to do or find out certain things

On this page I'll give you the tools that I use, perhaps they will come in handy for you.

eg.

1) Search Tool: Does an Internet search of the major sites eg. Google, MSN, MrExcel

2) Dumpbin: Here is a simple utility that scans import tables in Win32 modules for DLLs and APIs useful for scanning the system for instances of a particular API.

3) Getting Excel Object handles & Class names: Get the handles of the Excel objects and there Class names. This was used to get the Namebox dropdown listbox handle and class name for the Change namebox width routine.

4) Getting Document properties: If you have ever needed to get OR change (update) your office document properties then here is an Addin that will do this for you.

5) Save a Range as an Image: There are times when you may need to save an Excel range selection as an image file. I use this all the time to save images to try and explain something easier, remember a picture is worth a thousand words. Also used this for this sites images where applicable.

6) Gif Data to sheet. This Addin creates the data needed to create an animated gif within Excel so that you can use this on your userforms. Prior to this method the only other way was to place the animated gif in a directory to reference. (See write up)

NEW:

7) Hex File Dump: A workbook that will give you a Hexfile dump of any file.

8) NotePad ONTOP: A routine to keep NotePad ONTOP of all other windows. I find this handy for when I need to collate data from different applications and paste into one place, organize THEN copy & paste to Excel.