Несколько полезных программ. Не знаю может кому-то пригодится.
Excel VBA Sorting Progra 1.0
Excel VBA Sorting Progra 1.0 - 5 VBA Sort Functions - Quicksort, Heapsort , Selectionsort... Ive included the following sorting routines:1. Heap Sort2. Quick Sort3. Bubble Sort4. Counting Sort5. Selection SortI wrote a little subroutine that uses all of these functions so you can see how to use them.
http://www.runweloads.com/educat/comput ... dload.html
Excel: Regular Expressio 1.0
Excel: Regular Expressio 1.0 - Powerful VBA text searching and replacing Regular Expressions for Excel/VBAI show you how to use the incredible power of regular expressions to do searching and extracting in Excel VBA. Dont know what regular expressions is all about, then youre definitely missing out. I give two simple examples of how to use regular expressions. Ive set up the VBA code to make it very easy to use.I also include a subroutine to do search and replace.One of my examples show you how to extract everything between two HTML tags in Excel.If you need to parse files then you could load the file, search for things to replace with a tab, then do a split based on the tab. I use this technique on HTML files. I can split the file at certain tag points like the td tag the occurs right after a tr tag.
http://www.runweloads.com/educat/comput ... dload.html
Worksheet Booster, 1.0.1
Twenty essential tools accelerate routine worksheet operations that usually require several steps to accomplish. Each tool is accessible from the drop-down menu in one click. The user interface is carefully designed to be clean and easy even for complex tasks.
You can create email worksheets, workbooks or a selection; index worksheets; a workbook from selected worksheets, or a workbook from each selected worksheet; copy worksheets to each workbook in a selected folder; protect and unprotect a group of worksheets in one click; show and hide a selected worksheet and worksheets selected by wildcard; search and activate a required worksheet using wildcard; and advanced sort, delete, add, and rename worksheets.
http://www.nimblesoftware.com/ms-excel- ... t-booster/
http://soft.mail.ru/download_page.php?id=241182
Worksheet Search
Дополнение к Excel, позволяющее быстро найти и активировать нужный лист, используя поиск по маске.
http://www.nimblesoftware.com/ms-excel- ... et-search/
Recovery Toolbox for Excel
Утилита восстановления поврежденных файлов Microsoft Excel (файлов *.xls, *,xlt, *.xlsx, xlsm, *.xltm, *.xltx, *.xlam)
http://www.recoverytoolbox.com/ru/excel.html
данная программа платная ;(