![]() |
Programmer's Companion
Any one know of a programmer's companion to help keep track of a VBA
project? For example, I use Dreamweaver for web design. It allows me to analyze a web site for missing links and unused files. Something like that for Excel VBA would be nice. Thanks for your suggestions. Ken |
Programmer's Companion
Ken,
Take a look at Rob Bovey's Code Documenter http://www.appspro.com/Utilities/Documentor.htm -- HTH RP (remove nothere from the email address if mailing direct) "Ken Loomis" wrote in message ... Any one know of a programmer's companion to help keep track of a VBA project? For example, I use Dreamweaver for web design. It allows me to analyze a web site for missing links and unused files. Something like that for Excel VBA would be nice. Thanks for your suggestions. Ken |
Programmer's Companion
There is nothing like this that I know of. The best solution that I have
found is to comment your code include dsecriptions of all of your variables as soon as you get things working. This usually helps you find moat of the garbage that accumulates while you were writting. It is tough to add meaningful comments to garbage. I am with you though. The C/C++ compiler points out all of that garbage for you. -- HTH... Jim Thomlinson "Ken Loomis" wrote: Any one know of a programmer's companion to help keep track of a VBA project? For example, I use Dreamweaver for web design. It allows me to analyze a web site for missing links and unused files. Something like that for Excel VBA would be nice. Thanks for your suggestions. Ken |
Programmer's Companion
Roedd <<Ken Loomis wedi ysgrifennu:
Any one know of a programmer's companion to help keep track of a VBA project? This includes great tools for analyzing projects for unused variables, uncalled procedures etc. plus documentation tools and much more. It's free, too. http://www.mztools.com/v3/download.htm -- Rob http://www.asta51.dsl.pipex.com/webcam/ This message is copyright Robert Bruce and intended for distribution only via NNTP. Dissemination via third party Web forums with the exception of Google Groups and Microsoft Communities is strictly prohibited and may result in legal action. |
Programmer's Companion
I agree 100% with Robert - mztools is a great free gadget (and no, I do not
have any association with mz tools) that I have been using constantly for the last couple of years. -- www.alignment-systems.com "Robert Bruce" wrote: Roedd <<Ken Loomis wedi ysgrifennu: Any one know of a programmer's companion to help keep track of a VBA project? This includes great tools for analyzing projects for unused variables, uncalled procedures etc. plus documentation tools and much more. It's free, too. http://www.mztools.com/v3/download.htm -- Rob http://www.asta51.dsl.pipex.com/webcam/ This message is copyright Robert Bruce and intended for distribution only via NNTP. Dissemination via third party Web forums with the exception of Google Groups and Microsoft Communities is strictly prohibited and may result in legal action. |
All times are GMT +1. The time now is 03:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com