Developing.ru

Предлагаю в полезностях давать ссылки и на книги по VBA, Office'у у кого что есть?

My good friend Stephen's cool add-in. The BMS Smart Indenter is a utility to tidy up VBA code by rebuilding the indentation of each line.

You can read your favorite blogs from Excel.

The utility translate: Functions & formulas from the local language to English from, the contrary is also possible.

making Excel do the work for you

JMT Utilities
Цитата:making Excel do the work for you

A simple add-in to provide a quick risk assessment of a spreadsheet. Previously we have asked for an email address before allowing downloads of this, we collected thousands, and never abused those addresses. It would be nice if you email us if you download XLAnalyst, especially if you have some feedback (good or bad).

Вот сайт автора
http://www.andrewsexceltips.net/
Вот вроде рабочая ссылка http://puremis.net/excel/cgi-bin/cli..._Utilities.zip

This utility makes backup copies of VBA components to a user-defined directory. It keeps a user selectable number of copies of each component. It thus keeps a number of generations of your code as your work progresses, enabling you to return to a previous copy when things go wrong. Because it just exports the VBA components, it is unobtrusive because this process is relatively fast compared to saving your workbook or document. Excel and Word version included!!

This utility enables you to do Search and Replace operations in the Visual Basic Editor of Excel. What is special about this tool is that you can search for multiple lines of code and replace with multiple lines of code.